17.5.1.039-orioledb

feat: bump auth to v2.180.0 (#1829)

15.14.1.020

fix(pgmq): replace drop_queue function if exists (#1828)

* fix(pgmq): replace drop_queue function if exists

We introduced a patch to override pgmq.drop_queue(TEXT) to conditionally
drop objects only if they are part of the extension in `ansible/ansible/files/postgresql_extension_custom_scripts/pgmq/after-create.sql`
. This script might have been installed on installations with existing 1.4.4 extensions.

When the user tries to upgrade pgmq from 1.4.4 to 1.5.1, the upgrade
process will fail because the upgrade script doesn't expect
`pgmq.drop_queue(TEXT)` to exist.

This change introduce the a patch to the pgmq extension to use
`CREATE OR REPLACE FUNCTION` instead of `CREATE FUNCTION` for
`pgmq.drop_queue(TEXT)` in the upgrade script from 1.4.5 to 1.5.0.

* feat: test that the pgmq extension works well with the after create script

We create a new custom nixos test for the pgmq extension to test that the extension works
well with the after-create.sql script present in
`ansible/files/postgresql_extension_custom_scripts/pgmq/after-create.sql`.

* chore: bump versions to release post-rebase

---------

Co-authored-by: Sam Rose <samuel@supabase.io>

15.14.1.019

feat: support multiple versions of the pg_jsonschema extension (#1757)

* feat: multiple versions for the pg_jsonschema extension

Build multiple versions of the pg_jsonschema extension to on different PostgreSQL versions.
Add test for the extensions and their upgrade on PostgreSQL 15 and 17.

* fix: centralize bindgen hook override for pgrx extensions

Move the bindgen hook fix for ARM NEON vector ABI issues from
pg_graphql to mkPgrxExtension, making it available to all pgrx-based
extensions. This fix applies to pgrx versions 0.6.1 through 0.11.2
when building on aarch64-linux.

* fix: missing dependency on macOS for pg_jsonschema

* chore: bump to release

---------

Co-authored-by: Sam Rose <samuel@supabase.io>

15.14.1.018-fix-pgmq

chore: bump image releases for testing

15.14.1.018

feat: bump auth to v2.180.0 (#1829)

17.6.1.017

feat(migrations): predefined role grants (#1815)

* feat(migrations): predefined role grants

- supabase_etl_admin needs pg_monitor to query system catalog tables
(e.g. pg_replication_slots) - supabase_read_only_user needs pg_monitor
to view queries in pg_stat_statements - grant pg_create_subscription to
postgres with admin option in case users want to create subscriptions
with their own roles

* chore: bump version

* test: update

* chore: bump versions

17.6.1.016-pgmqfix-1

chore: bump suffix to test in local infra

17.6.1.015-pg-jsonschema-1

fix: missing dependency on macOS for pg_jsonschema

17.5.1.038-orioledb

feat(migrations): predefined role grants (#1815)

* feat(migrations): predefined role grants

- supabase_etl_admin needs pg_monitor to query system catalog tables
(e.g. pg_replication_slots) - supabase_read_only_user needs pg_monitor
to view queries in pg_stat_statements - grant pg_create_subscription to
postgres with admin option in case users want to create subscriptions
with their own roles

* chore: bump version

* test: update

* chore: bump versions

17.5.1.037-orioledb-pgmqfix-1

chore: bump suffix to test in local infra