Grow Trunk Repo

[theory]

Add as many distributions to the #45 repository as possible. Goals:

• All PGXN distributions with releases in 2023 or later
• All core extensions
• All non-core extensions on pgt.dev

For PGXN extensions, start by repairing and patching v1 META.json files:

• Test and repair & re-index all invalid v1 META.json files on PGXN
• Test v1-v2 Metadata migration for all META.json files on PGXN
  • Develop merge patches to fix errors, including:
    • Missing maintainer names/contacts
    • Missing/incorrect license values
    • Inaccurate control file locations
    • Invalid sql file locations
    • Indexing modules and apps
  • Fix or expand migration issues in the pgxn_meta::meta::v1 module
    where appropriate
  • Use said merge patches in the packaging source registry (listed under
    "Building" above)

Where possible, work with maintainers to get their extensions released on PGXN through an automated release process (e.g., GitHub workflows using pgxn-tools.