postgres Update nixpkgs

Use one recent version of nixpkgs in the flake inputs.

a76c4553d7e741e17f289224eda135423de0491d -> f61125a668a320878494449750330ca58b78c557

Jul 21 '25 10:07 jfroche

rebased on develop, and will e2e test ami for each major version

Aug 08 '25 16:08 samrose

pause/restore tests

============================================================
Supadev PostgreSQL Pause/Restore Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17 17-oriole
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-pause-1765923158
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714


============================================================
Inserting Versions from PR as GA
============================================================
[STEP] Resolving version from PR for engine 15...
[SUCCESS] Resolved version for 15: 15.14.1.064-update-nixpkgs-4
[STEP] Inserting version 15.14.1.064-update-nixpkgs-4 as GA...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 1
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine 
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-4 | us-east-1 | ami-0f0ea6db5b9a40693 | ga              | 15
(1 row)


[SUCCESS] Version 15.14.1.064-update-nixpkgs-4 inserted as GA
[STEP] Resolving version from PR for engine 17...
[SUCCESS] Resolved version for 17: 17.6.1.064-update-nixpkgs-4
[STEP] Inserting version 17.6.1.064-update-nixpkgs-4 as GA...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 1
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine 
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-4 | us-east-1 | ami-0fa3c3128ead769b3 | ga              | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-4 inserted as GA
[STEP] Resolving version from PR for engine 17-oriole...
[SUCCESS] Resolved version for 17-oriole: 17.6.0.021-orioledb-update-nixpkgs-4
[STEP] Inserting version 17.6.0.021-orioledb-update-nixpkgs-4 as GA...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 1
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine 
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-4 | us-east-1 | ami-0aa81b6ec92c27b16 | ga              | 17-oriole
(1 row)


[SUCCESS] Version 17.6.0.021-orioledb-update-nixpkgs-4 inserted as GA


============================================================
Testing PostgreSQL Pause/Restore: 15
============================================================
[INFO] Project name: supadev-pause-1765923158-pg15
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-16 17:12:42
[INFO] Using version: 15.14.1.064-update-nixpkgs-4
[STEP] Creating project with PostgresEngine 15...
http://localhost:8082/project/tccfkozuqlmhdxkcwpcz
Database status is not yet available, waiting...
Database status is currently UNKNOWN, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg15 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 313 seconds

[STEP] Pausing project supadev-pause-1765923158-pg15...
Project paused
Pause status is currently PAUSING, waiting...
Pause status is now INACTIVE
[SUCCESS] Project supadev-pause-1765923158-pg15 paused successfully
[INFO] Time to pause: 61 seconds
[STEP] Restoring project supadev-pause-1765923158-pg15...
{
  "id": 7,
  "status": "INACTIVE",
  "organization_id": 1,
  "region": "us-east-1",
  "cloud_provider": "AWS"
}
Restoration status is currently INACTIVE, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently RESTORING, waiting...
Restoration status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg15 restored successfully
[INFO] Time to restore: 301 seconds

[STEP] Deleting project supadev-pause-1765923158-pg15...
Project deleted
[SUCCESS] Project supadev-pause-1765923158-pg15 deleted successfully
[SUCCESS] PostgresEngine 15 pause/restore test completed successfully
[INFO] Total test duration: 675 seconds


============================================================
Testing PostgreSQL Pause/Restore: 17
============================================================
[INFO] Project name: supadev-pause-1765923158-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-16 17:23:57
[INFO] Using version: 17.6.1.064-update-nixpkgs-4
[STEP] Creating project with PostgresEngine 17...
http://localhost:8082/project/gfmwuhznehadqwtuhgxz
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg17 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 258 seconds

[STEP] Pausing project supadev-pause-1765923158-pg17...
Project paused
Pause status is currently PAUSING, waiting...
Pause status is now INACTIVE
[SUCCESS] Project supadev-pause-1765923158-pg17 paused successfully
[INFO] Time to pause: 61 seconds
[STEP] Restoring project supadev-pause-1765923158-pg17...
{
  "id": 8,
  "status": "INACTIVE",
  "organization_id": 1,
  "region": "us-east-1",
  "cloud_provider": "AWS"
}
Restoration status is currently INACTIVE, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently RESTORING, waiting...
Restoration status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg17 restored successfully
[INFO] Time to restore: 301 seconds

[STEP] Deleting project supadev-pause-1765923158-pg17...
Project deleted
[SUCCESS] Project supadev-pause-1765923158-pg17 deleted successfully
[SUCCESS] PostgresEngine 17 pause/restore test completed successfully
[INFO] Total test duration: 621 seconds


============================================================
Testing PostgreSQL Pause/Restore: 17-oriole
============================================================
[INFO] Project name: supadev-pause-1765923158-pg17_oriole
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-16 17:34:18
[INFO] Using version: 17.6.0.021-orioledb-update-nixpkgs-4
[STEP] Creating project with PostgresEngine 17-oriole...
http://localhost:8082/project/gsxgkblqhuikxnifxicv
Database status is not yet available, waiting...
Database status is currently UNKNOWN, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg17_oriole created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 257 seconds

[STEP] Pausing project supadev-pause-1765923158-pg17_oriole...
Project paused
Pause status is currently PAUSING, waiting...
Pause status is now INACTIVE
[SUCCESS] Project supadev-pause-1765923158-pg17_oriole paused successfully
[INFO] Time to pause: 60 seconds
[STEP] Restoring project supadev-pause-1765923158-pg17_oriole...
{
  "id": 9,
  "status": "INACTIVE",
  "organization_id": 1,
  "region": "us-east-1",
  "cloud_provider": "AWS"
}
Restoration status is currently INACTIVE, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently COMING_UP, waiting...
Restoration status is currently RESTORING, waiting...
Restoration status is currently RESTORING, waiting...
Restoration status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-pause-1765923158-pg17_oriole restored successfully
[INFO] Time to restore: 362 seconds

[STEP] Deleting project supadev-pause-1765923158-pg17_oriole...
Project deleted
[SUCCESS] Project supadev-pause-1765923158-pg17_oriole deleted successfully
[SUCCESS] PostgresEngine 17-oriole pause/restore test completed successfully
[INFO] Total test duration: 679 seconds


============================================================
Cleaning Up: Withdrawing Inserted Versions
============================================================
[STEP] Withdrawing version 15.14.1.064-update-nixpkgs-4 for engine 15...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine 
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-4 | us-east-1 | ami-0f0ea6db5b9a40693 | withdrawn       | 15
(1 row)


[SUCCESS] Version 15.14.1.064-update-nixpkgs-4 marked as withdrawn
[STEP] Withdrawing version 17.6.1.064-update-nixpkgs-4 for engine 17...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine 
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-4 | us-east-1 | ami-0fa3c3128ead769b3 | withdrawn       | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-4 marked as withdrawn
[STEP] Withdrawing version 17.6.0.021-orioledb-update-nixpkgs-4 for engine 17-oriole...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine 
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-4 | us-east-1 | ami-0aa81b6ec92c27b16 | withdrawn       | 17-oriole
(1 row)


[SUCCESS] Version 17.6.0.021-orioledb-update-nixpkgs-4 marked as withdrawn

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (675s)
17              PASSED (621s)
17-oriole       PASSED (679s)

============================================================
Total: 3 | Passed: 3 | Failed: 0
============================================================
[SUCCESS] All tests passed!

Dec 16 '25 22:12 samrose

upgrade succeeded, ran into some test framework bugs so will retest that tomorrow

Dec 16 '25 23:12 samrose

@LGUG2Z could we ask you to run comprehensive testing on this PR when you have a chance?

Dec 18 '25 21:12 samrose

The Engines scenario successfully created projects with the entire supported PostgresEngines matrix:

❯ ./scripts/test-postgres-engines.sh https://github.com/supabase/postgres/pull/1714

============================================================
Supadev PostgreSQL Engine Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17 17-oriole
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-test-1766096309
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714


============================================================
Testing PostgreSQL Engine: 15
============================================================
[INFO] Project name: supadev-test-1766096309-pg15
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 14:18:29
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 15.14.1.064-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 15...
INSERT 0 1
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-5 | us-east-1 | ami-039caa3662c5f0532 | ga              | 15
(1 row)


Creating project on release channel "internal" with version "15.14.1.064-update-nixpkgs-5"
Project URL: http://localhost:8082/project/nvefcrotcfvisgnnfuyg
Admin URL: http://localhost:4000/projects?identifier=nvefcrotcfvisgnnfuyg
Database status is not yet available, waiting...
Database status is currently UNKNOWN, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766096309-pg15 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 315 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766096309-pg15...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information for supadev-test-1766096309-pg15
{
  "cloud_provider": "AWS",
  "db_host": "db.nvefcrotcfvisgnnfuyg.supabase.red",
  "id": 16,
  "inserted_at": "2025-12-18T22:18:33.573183",
  "name": "supadev-test-1766096309-pg15",
  "organization_id": 1,
  "ref": "nvefcrotcfvisgnnfuyg",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX18A9ihTPviqvDZfCoVUblwftwkaIQzJfG6rRSajXnWoraN9fQe4SPWrpFRM/kZRAzC8PF34tEEj+luEjlX+NLb40UoeWJDI/Kmlx49TXNAR/ogpoJrB8HPIhnIEUky4h8eUy/K0Lw5eIIY7pzzCxEc9SCTBqu/TnUm6foorpNnJBSCxw+S5d+Io",
  "restUrl": "https://nvefcrotcfvisgnnfuyg.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "15.14.1.064-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766096309-pg15...
Project deleted
[SUCCESS] Project supadev-test-1766096309-pg15 deleted successfully
[SUCCESS] PostgresEngine 15 test completed successfully
[INFO] Total test duration: 327 seconds


============================================================
Testing PostgreSQL Engine: 17
============================================================
[INFO] Project name: supadev-test-1766096309-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 14:23:56
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 17.6.1.064-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 17...
INSERT 0 1
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga              | 17
(1 row)


Creating project on release channel "internal" with version "17.6.1.064-update-nixpkgs-5"
Project URL: http://localhost:8082/project/rxcowbiqmgmokxbwnfpu
Admin URL: http://localhost:4000/projects?identifier=rxcowbiqmgmokxbwnfpu
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766096309-pg17 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 254 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766096309-pg17...
Waiting for all project components to become healthy, 4 retry attempt(s) remaining...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d00:845:3edb:f6ce:3436",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information for supadev-test-1766096309-pg17
{
  "cloud_provider": "AWS",
  "db_host": "db.rxcowbiqmgmokxbwnfpu.supabase.red",
  "id": 17,
  "inserted_at": "2025-12-18T22:24:00.094531",
  "name": "supadev-test-1766096309-pg17",
  "organization_id": 1,
  "ref": "rxcowbiqmgmokxbwnfpu",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX18Kpz+po/8svgdOB67cpoVIE0dD3C5KaKGcY5Brt4v+9T5ZqVZwBssSvWfLR8uxIySvQSaouTNqMlA8i8SYELctwLnCS9VabSWkOaKNWPz9UzpaP/JYXg1/sWpeSZOIrlzCnDEsfpTeoVK1MqM5Xem+1FDNNGBpfvWwKho3YqJnfwsi5mPyXNQM",
  "restUrl": "https://rxcowbiqmgmokxbwnfpu.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "17.6.1.064-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766096309-pg17...
Project deleted
[SUCCESS] Project supadev-test-1766096309-pg17 deleted successfully
[SUCCESS] PostgresEngine 17 test completed successfully
[INFO] Total test duration: 290 seconds


============================================================
Testing PostgreSQL Engine: 17-oriole
============================================================
[INFO] Project name: supadev-test-1766096309-pg17_oriole
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 14:28:46
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 17.6.0.021-orioledb-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 17-oriole...
INSERT 0 1
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-5 | us-east-1 | ami-0c2a7b752b30de150 | ga              | 17-oriole
(1 row)


Creating project on release channel "internal" with version "17.6.0.021-orioledb-update-nixpkgs-5"
Project URL: http://localhost:8082/project/lwrakrtnmumnzzhwqovq
Admin URL: http://localhost:4000/projects?identifier=lwrakrtnmumnzzhwqovq
Database status is not yet available, waiting...
Database status is currently UNKNOWN, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766096309-pg17_oriole created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 253 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766096309-pg17_oriole...
Waiting for all project components to become healthy, 4 retry attempt(s) remaining...
Waiting for all project components to become healthy, 3 retry attempt(s) remaining...
Waiting for all project components to become healthy, 2 retry attempt(s) remaining...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information for supadev-test-1766096309-pg17_oriole
{
  "cloud_provider": "AWS",
  "db_host": "db.lwrakrtnmumnzzhwqovq.supabase.red",
  "id": 18,
  "inserted_at": "2025-12-18T22:28:49.410412",
  "name": "supadev-test-1766096309-pg17_oriole",
  "organization_id": 1,
  "ref": "lwrakrtnmumnzzhwqovq",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX18gCoVVrXKP2sqLa3iPUPYHWF+DYYPNW4EcszGX/EqwXyYZl9gYq2Gf+e8qGTT6eEan+B0zwifCbuYgIKSZgNYrI+6RMts+6quFmclZKgmDukqzO0iqu1D103QEdGvTV/E03mgmHlrGu5tJXXhIVBQ0eBrG9PLGmhByHxKwS13y7EIpRjj1k1ro",
  "restUrl": "https://lwrakrtnmumnzzhwqovq.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "17.6.0.021-orioledb-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766096309-pg17_oriole...
Project deleted
[SUCCESS] Project supadev-test-1766096309-pg17_oriole deleted successfully
[SUCCESS] PostgresEngine 17-oriole test completed successfully
[INFO] Total test duration: 315 seconds


============================================================
Cleaning Up: Withdrawing Inserted Versions
============================================================
[STEP] Withdrawing version 15.14.1.064-update-nixpkgs-5 for engine 15...
INSERT 0 0
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-5 | us-east-1 | ami-039caa3662c5f0532 | withdrawn       | 15
(1 row)


[SUCCESS] Version 15.14.1.064-update-nixpkgs-5 marked as withdrawn
[STEP] Withdrawing version 17.6.1.064-update-nixpkgs-5 for engine 17...
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 marked as withdrawn
[STEP] Withdrawing version 17.6.0.021-orioledb-update-nixpkgs-5 for engine 17-oriole...
INSERT 0 0
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-5 | us-east-1 | ami-0c2a7b752b30de150 | withdrawn       | 17-oriole
(1 row)


[SUCCESS] Version 17.6.0.021-orioledb-update-nixpkgs-5 marked as withdrawn

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (327s)
17              PASSED (290s)
17-oriole       PASSED (315s)

============================================================
Total: 3 | Passed: 3 | Failed: 0
============================================================
[SUCCESS] All tests passed!

Dec 18 '25 22:12 LGUG2Z

Failures on the smoke test here are related to DNS propagation, possibly related to my own network stack at home as only the initial post-upgrade SQL exec has a connection failure to the DB DNS record, I would consider this a pass

❯ ./scripts/test-postgres-smoke.sh https://github.com/supabase/postgres/pull/1714

============================================================
Supadev PostgreSQL Smoke Upgrade Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-smoke-1766099724
[INFO] SQL smoke directory: /Users/lgug2z/supadev/sql/smoke
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714


============================================================
Testing PostgreSQL Smoke Upgrade: 15
============================================================
[INFO] Project name: supadev-smoke-1766099724-pg15
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 15:15:24
[STEP] Resolving version from PR for upgrade target engine 17...
[SUCCESS] Resolved version: 17.6.1.064-update-nixpkgs-5
[STEP] Ensuring version 17.6.1.064-update-nixpkgs-5 is withdrawn...
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)


[STEP] Creating project with PostgresEngine 15...
Creating project on release channel "ga" with version "supabase-postgres-15.14.1.063"
Project URL: http://localhost:8082/project/hodldlmwicpgnddusnby
Admin URL: http://localhost:4000/projects?identifier=hodldlmwicpgnddusnby
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-smoke-1766099724-pg15 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 194 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766099724-pg15...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d00:845:3edb:f6ce:3436",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information before upgrade...
{
  "cloud_provider": "AWS",
  "db_host": "db.hodldlmwicpgnddusnby.supabase.red",
  "id": 21,
  "inserted_at": "2025-12-18T23:15:27.656531",
  "name": "supadev-smoke-1766099724-pg15",
  "organization_id": 1,
  "ref": "hodldlmwicpgnddusnby",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX198tVEcPCp+GcwI55hCZgWoNQyGMJ6BWfhJr4YgeNlWc9KOAmoYRtjY7u9LxPOcrwgmA9Ji+4FTQTCHly6bH+s/jc087A+3QsKr8IpdkjnXRpIGrK8QH2OsrFgR6nx0KqpyFFGuX3EOL9bKF1Ju0Hga96juYhWsXW+xBXt64WguflfwIZ9puD5D",
  "restUrl": "https://hodldlmwicpgnddusnby.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "supabase-postgres-15.14.1.063"
}

============================================================
Executing pre-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql
[INFO] SQL output:
CREATE EXTENSION
 create
--------

(1 row)

 send
------
    1
(1 row)
[SUCCESS] Found expected string (line 1): CREATE EXTENSION
[SUCCESS] Found expected string (line 2): create
[SUCCESS] Found expected string (line 3): send
[SUCCESS] Found expected string (line 4): 1
[SUCCESS] Verification passed for: 01-pgmq.sql

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
CREATE TABLE
INSERT 0 2
  name
--------
 First
 Second
(2 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): INSERT 0 2
[SUCCESS] Found expected string (line 3): name
[SUCCESS] Found expected string (line 4): First
[SUCCESS] Found expected string (line 5): Second
[SUCCESS] Verification passed for: 02-items.sql

[STEP] Executing SQL: 03-event_trigger.sql
[INFO] SQL output:
CREATE FUNCTION
CREATE EVENT TRIGGER
[SUCCESS] Found expected string (line 1): CREATE FUNCTION
[SUCCESS] Found expected string (line 2): CREATE EVENT TRIGGER
[SUCCESS] Verification passed for: 03-event_trigger.sql

[STEP] Executing SQL: 04-subitems.sql
[INFO] SQL output:
CREATE TABLE
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00
(3 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): name
[SUCCESS] Found expected string (line 3): First
[SUCCESS] Found expected string (line 4): Second
[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Verification passed for: 04-subitems.sql

[SUCCESS] All pre-upgrade SQL files executed and verified successfully
[STEP] Inserting version 17.6.1.064-update-nixpkgs-5 as GA...
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga              | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 inserted as GA
[STEP] Printing project upgrade eligibility...
{
  "eligible": true,
  "current_app_version": "supabase-postgres-15.14.1.063",
  "current_app_version_release_channel": "ga",
  "latest_app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5",
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5"
    },
    {
      "postgres_version": "17",
      "release_channel": "internal",
      "app_version": "supabase-postgres-17.4.1.077"
    }
  ],
  "duration_estimate_hours": 1,
  "legacy_auth_custom_roles": [],
  "objects_to_be_dropped": [],
  "unsupported_extensions": [],
  "user_defined_objects_in_internal_schemas": []
}
[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.064-update-nixpkgs-5...
Upgrade status is not yet available, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade completed (status inferred by empty API response)
[SUCCESS] Project supadev-smoke-1766099724-pg15 upgraded successfully
[INFO] Time to complete upgrade: 636 seconds
[INFO] Sleeping for 60 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766099724-pg15...
Waiting for all project components to become healthy, 9 retry attempt(s) remaining...
Waiting for all project components to become healthy, 8 retry attempt(s) remaining...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information after upgrade...
{
  "cloud_provider": "AWS",
  "db_host": "db.hodldlmwicpgnddusnby.supabase.red",
  "id": 21,
  "inserted_at": "2025-12-18T23:15:27.656531",
  "name": "supadev-smoke-1766099724-pg15",
  "organization_id": 1,
  "ref": "hodldlmwicpgnddusnby",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1/YnVHAYABon/GHOWCgxErIS9Uc+oQWvSe0CLD+/RlHWeldEDoOfu75ds45dNq2pxUjl0r3k+qyNOZJH3sVL/E8U323Sc/JsRk2ojNBHh9G2cR3WbFUEHwDP4VEupYwQLX94zxNMFPsljBU91WV1IaA2MH4iEYQiJXqyvKA0ag7GWy1ClB3QEJZ",
  "restUrl": "https://hodldlmwicpgnddusnby.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "supabase-postgres-17.6.1.064-update-nixpkgs-5"
}

============================================================
Executing post-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql                                                                                                                                                                                         [ERROR] Failed to execute SQL file: 01-pgmq.sql
[ERROR] Output: Error:
   0: psql failed: psql: error: connection to server at "db.hodldlmwicpgnddusnby.supabase.red" (2600:1f18:22a5:ad04:bf53:b9ed:e042:30d5), port 5432 failed: Network is unreachable
        Is the server running on that host and accepting TCP/IP connections?


Location:
   src/psql.rs:137

  ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BACKTRACE ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
                                ⋮ 6 frames hidden ⋮
   7: supadev::psql::execute_sql_file::hfe1c523b5fb4db2d
      at <unknown source file>:<unknown line>
   8: supadev::main::h2456504d0c926344
      at <unknown source file>:<unknown line>
   9: std::sys::backtrace::__rust_begin_short_backtrace::h3544633b4c27a310
      at <unknown source file>:<unknown line>
  10: std::rt::lang_start::{{closure}}::h2e5ceb56fe3b4c49
      at <unknown source file>:<unknown line>
  11: std::rt::lang_start_internal::hd700ba983d3377dc
      at <unknown source file>:<unknown line>
  12: _main<unknown>
      at <unknown source file>:<unknown line>

Run with COLORBT_SHOW_HIDDEN=1 environment variable to disable frame filtering.
Run with RUST_BACKTRACE=full to include source snippets.

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00
(3 rows)
[SUCCESS] Found expected string (line 1): name
[SUCCESS] Found expected string (line 2): First
[SUCCESS] Found expected string (line 3): Second
[SUCCESS] Found expected string (line 4): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Verification passed for: 02-items.sql

[STEP] Executing SQL: 03-subitems.sql
[INFO] SQL output:
CREATE TABLE
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00
 CREATE TABLE - public.subitems_2 - public - 2025-12-18 23:32:02.461059+00
(4 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): name
[SUCCESS] Found expected string (line 3): First
[SUCCESS] Found expected string (line 4): Second
[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Found expected string (line 6): CREATE TABLE - public.subitems_2 - public
[SUCCESS] Verification passed for: 03-subitems.sql

[ERROR] post-upgrade SQL verification failed
[ERROR] Post-upgrade SQL verification failed
[INFO] Project supadev-smoke-1766099724-pg15 left intact for manual inspection
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)




============================================================
Testing PostgreSQL Smoke Upgrade: 17
============================================================
[INFO] Project name: supadev-smoke-1766099724-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 15:32:04
[STEP] Resolving version from PR for upgrade target engine 17...
[SUCCESS] Resolved version: 17.6.1.064-update-nixpkgs-5
[STEP] Ensuring version 17.6.1.064-update-nixpkgs-5 is withdrawn...
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)


[STEP] Creating project with PostgresEngine 17...
Creating project on release channel "ga" with version "supabase-postgres-17.6.1.063"
Project URL: http://localhost:8082/project/fbuixzflrwchmiztbbie
Admin URL: http://localhost:4000/projects?identifier=fbuixzflrwchmiztbbie
Database status is not yet available, waiting...                                                                                                                                                                    Database status is now ACTIVE_HEALTHYMING_UP, waiting....
[SUCCESS] Project supadev-smoke-1766099724-pg17 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 133 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766099724-pg17...
Waiting for all project components to become healthy, 4 retry attempt(s) remaining...
Waiting for all project components to become healthy, 3 retry attempt(s) remaining...
Waiting for all project components to become healthy, 2 retry attempt(s) remaining...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information before upgrade...
{
  "cloud_provider": "AWS",
  "db_host": "db.fbuixzflrwchmiztbbie.supabase.red",
  "id": 22,
  "inserted_at": "2025-12-18T23:32:07.178628",
  "name": "supadev-smoke-1766099724-pg17",
  "organization_id": 1,
  "ref": "fbuixzflrwchmiztbbie",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1/y33ryKx1337UewtXfQGlPcdHYdP5COvFAJDP/+6VKqe1Up/JWrjkJBMj1J08BJWpW8TS6hAQAqU+kkPR9Up9xN0fjdsQVRarkK2qP/6rGbFe1nbpm8Ep/JUkJVh2LmyjScZSSNVi/XNZ66I0jqdT+9WTf/i1ob5zQKemaFZB4QqYfswO+KGQC",
  "restUrl": "https://fbuixzflrwchmiztbbie.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "supabase-postgres-17.6.1.063"
}

============================================================
Executing pre-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql
[INFO] SQL output:
CREATE EXTENSION
 create
--------

(1 row)

 send
------
    1
(1 row)
[SUCCESS] Found expected string (line 1): CREATE EXTENSION
[SUCCESS] Found expected string (line 2): create
[SUCCESS] Found expected string (line 3): send
[SUCCESS] Found expected string (line 4): 1
[SUCCESS] Verification passed for: 01-pgmq.sql

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
CREATE TABLE
INSERT 0 2
  name
--------
 First
 Second
(2 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): INSERT 0 2
[SUCCESS] Found expected string (line 3): name
[SUCCESS] Found expected string (line 4): First
[SUCCESS] Found expected string (line 5): Second
[SUCCESS] Verification passed for: 02-items.sql

[STEP] Executing SQL: 03-event_trigger.sql
[INFO] SQL output:
CREATE FUNCTION
CREATE EVENT TRIGGER
[SUCCESS] Found expected string (line 1): CREATE FUNCTION
[SUCCESS] Found expected string (line 2): CREATE EVENT TRIGGER
[SUCCESS] Verification passed for: 03-event_trigger.sql

[STEP] Executing SQL: 04-subitems.sql
[INFO] SQL output:
CREATE TABLE
                                  name
-------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00
(3 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): name
[SUCCESS] Found expected string (line 3): First
[SUCCESS] Found expected string (line 4): Second
[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Verification passed for: 04-subitems.sql

[SUCCESS] All pre-upgrade SQL files executed and verified successfully
[STEP] Inserting version 17.6.1.064-update-nixpkgs-5 as GA...
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga              | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 inserted as GA
[STEP] Printing project upgrade eligibility...
{
  "eligible": true,
  "current_app_version": "supabase-postgres-17.6.1.063",
  "current_app_version_release_channel": "ga",
  "latest_app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5",
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5"
    }
  ],
  "duration_estimate_hours": 1,
  "legacy_auth_custom_roles": [],
  "objects_to_be_dropped": [],
  "unsupported_extensions": [],
  "user_defined_objects_in_internal_schemas": []
}
[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.064-update-nixpkgs-5...
Upgrade status is not yet available, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 1_started, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade status is currently 5_initiated_data_upgrade, waiting...
Upgrade completed (status inferred by empty API response)
[SUCCESS] Project supadev-smoke-1766099724-pg17 upgraded successfully
[INFO] Time to complete upgrade: 687 seconds
[INFO] Sleeping for 60 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766099724-pg17...
Waiting for all project components to become healthy, 9 retry attempt(s) remaining...
Waiting for all project components to become healthy, 8 retry attempt(s) remaining...
Waiting for all project components to become healthy, 7 retry attempt(s) remaining...
[
  {
    "name": "PostgREST",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "db_schema": "public,graphql_public"
    }
  },
  {
    "name": "Auth",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "description": "GoTrue is a user registration and authentication API",
      "name": "GoTrue",
      "version": "v2.184.0"
    }
  },
  {
    "name": "Storage",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Realtime",
    "healthy": true,
    "status": "ACTIVE_HEALTHY",
    "info": {
      "connected_cluster": 0,
      "db_connected": false,
      "healthy": true,
      "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214",
      "region": "us-west-2"
    }
  },
  {
    "name": "Postgres (Admin)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Postgres (User)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "Supavisor (TXN)",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  },
  {
    "name": "PgBouncer",
    "healthy": true,
    "status": "ACTIVE_HEALTHY"
  }
]
[STEP] Printing project information after upgrade...
{
  "cloud_provider": "AWS",
  "db_host": "db.fbuixzflrwchmiztbbie.supabase.red",
  "id": 22,
  "inserted_at": "2025-12-18T23:32:07.178628",
  "name": "supadev-smoke-1766099724-pg17",
  "organization_id": 1,
  "ref": "fbuixzflrwchmiztbbie",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1+AvpdkZoDa+rsxGNvh5JSgLB9owSD1kzIaioiGyDd5U1IKu90tlgy1Iyx85jkMwkESUGSohCmTbx+sVJcCv+ageP94XG2e6lT7hnrfTjrqMp924V/syJ2yEeV3LuLgz3egbhuehsDiWylDOxlOGTAt7pR9UUPhlM2chgKDQUp2nIVP+kKHpwpA",
  "restUrl": "https://fbuixzflrwchmiztbbie.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "supabase-postgres-17.6.1.064-update-nixpkgs-5"
}

============================================================
Executing post-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql
[ERROR] Failed to execute SQL file: 01-pgmq.sql
[ERROR] Output: Error:
   0: psql failed: psql: error: connection to server at "db.fbuixzflrwchmiztbbie.supabase.red" (2600:1f18:22a5:ad01:d49a:4b94:e56e:9371), port 5432 failed: Network is unreachable
        Is the server running on that host and accepting TCP/IP connections?


Location:
   src/psql.rs:137

  ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BACKTRACE ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
                                ⋮ 6 frames hidden ⋮
   7: supadev::psql::execute_sql_file::hfe1c523b5fb4db2d
      at <unknown source file>:<unknown line>
   8: supadev::main::h2456504d0c926344
      at <unknown source file>:<unknown line>
   9: std::sys::backtrace::__rust_begin_short_backtrace::h3544633b4c27a310
      at <unknown source file>:<unknown line>
  10: std::rt::lang_start::{{closure}}::h2e5ceb56fe3b4c49
      at <unknown source file>:<unknown line>
  11: std::rt::lang_start_internal::hd700ba983d3377dc
      at <unknown source file>:<unknown line>
  12: _main<unknown>
      at <unknown source file>:<unknown line>

Run with COLORBT_SHOW_HIDDEN=1 environment variable to disable frame filtering.
Run with RUST_BACKTRACE=full to include source snippets.

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
                                  name
-------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00
(3 rows)
[SUCCESS] Found expected string (line 1): name
[SUCCESS] Found expected string (line 2): First
[SUCCESS] Found expected string (line 3): Second
[SUCCESS] Found expected string (line 4): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Verification passed for: 02-items.sql

[STEP] Executing SQL: 03-subitems.sql
[INFO] SQL output:
CREATE TABLE
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00
 CREATE TABLE - public.subitems_2 - public - 2025-12-18 23:48:43.945853+00
(4 rows)
[SUCCESS] Found expected string (line 1): CREATE TABLE
[SUCCESS] Found expected string (line 2): name
[SUCCESS] Found expected string (line 3): First
[SUCCESS] Found expected string (line 4): Second
[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public
[SUCCESS] Found expected string (line 6): CREATE TABLE - public.subitems_2 - public
[SUCCESS] Verification passed for: 03-subitems.sql

[ERROR] post-upgrade SQL verification failed
[ERROR] Post-upgrade SQL verification failed
[INFO] Project supadev-smoke-1766099724-pg17 left intact for manual inspection
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)




============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              FAILED (post-upgrade SQL)
17              FAILED (post-upgrade SQL)

============================================================
Total: 2 | Passed: 0 | Failed: 2
============================================================
[ERROR] Some tests failed!

Dec 18 '25 23:12 LGUG2Z

@LGUG2Z I am going to repeat these tests due to the amount of changes in this PR

Dec 19 '25 14:12 samrose

retest engine

============================================================
Supadev PostgreSQL Engine Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17 17-oriole
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-test-1766171008
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714


============================================================
Testing PostgreSQL Engine: 15
============================================================
[INFO] Project name: supadev-test-1766171008-pg15
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-19 14:03:28
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 15.14.1.064-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 15...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine 
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-5 | us-east-1 | ami-039caa3662c5f0532 | ga              | 15
(1 row)


http://localhost:8082/project/jjrnummxyanyhydunjxy
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766171008-pg15 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 319 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766171008-pg15...
error: unrecognized subcommand 'project-health'

  tip: some similar subcommands exist: 'project-upgrade-eligibility', 'project-information', 'project-id'

Usage: supadev <COMMAND>

For more information, try '--help'.
[STEP] Printing project information for supadev-test-1766171008-pg15
{
  "cloud_provider": "AWS",
  "db_host": "db.jjrnummxyanyhydunjxy.supabase.red",
  "id": 5,
  "inserted_at": "2025-12-19T19:03:35.829928",
  "name": "supadev-test-1766171008-pg15",
  "organization_id": 1,
  "ref": "jjrnummxyanyhydunjxy",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "4UBPqvTF5gpecaCB",
  "connectionString": "U2FsdGVkX1+fkAj/6pk7yg/InMLsuQFY1K6UOBE4PPH9UbdBEqACeCCC5BPlv9Ngg4Ov1RPXgJga7+pA5LQTS5DLpJ+eE2O5FvBIDujssX3nh6RQ7Yp9pFHBd/jxfdzw/i41tZgJUcOULoULf9f74uDBAFLt02+bqp/aCB2nxbU4rkAdrv/GDFOsoqAgl7sj",
  "restUrl": "https://jjrnummxyanyhydunjxy.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "15.14.1.064-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766171008-pg15...
Project deleted
[SUCCESS] Project supadev-test-1766171008-pg15 deleted successfully
[SUCCESS] PostgresEngine 15 test completed successfully
[INFO] Total test duration: 330 seconds


============================================================
Testing PostgreSQL Engine: 17
============================================================
[INFO] Project name: supadev-test-1766171008-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-19 14:08:58
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 17.6.1.064-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 17...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine 
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga              | 17
(1 row)


http://localhost:8082/project/jykketiwbarpganxgohv
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766171008-pg17 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 198 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766171008-pg17...
error: unrecognized subcommand 'project-health'

  tip: some similar subcommands exist: 'project-upgrade-eligibility', 'project-information', 'project-id'

Usage: supadev <COMMAND>

For more information, try '--help'.
[STEP] Printing project information for supadev-test-1766171008-pg17
{
  "cloud_provider": "AWS",
  "db_host": "db.jykketiwbarpganxgohv.supabase.red",
  "id": 6,
  "inserted_at": "2025-12-19T19:09:05.810614",
  "name": "supadev-test-1766171008-pg17",
  "organization_id": 1,
  "ref": "jykketiwbarpganxgohv",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "4UBPqvTF5gpecaCB",
  "connectionString": "U2FsdGVkX18HYU7yluCYVZhQcwD5QjgtoqOx+bC0hC+seScJQVMui5NqFJp8YhB4y3p8Rmth4kZLRdRQwu23KwCznyKfDCx0MQcXEGueOhM0L7hHA1h+ZRxkWmKvPKJpTlq53ZLYWYoadgb+p7nRzKlQtHIIhUL74eZr9faNpGdh9p6joE5Omr+Ujarcmr4Q",
  "restUrl": "https://jykketiwbarpganxgohv.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "17.6.1.064-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766171008-pg17...
Project deleted
[SUCCESS] Project supadev-test-1766171008-pg17 deleted successfully
[SUCCESS] PostgresEngine 17 test completed successfully
[INFO] Total test duration: 209 seconds


============================================================
Testing PostgreSQL Engine: 17-oriole
============================================================
[INFO] Project name: supadev-test-1766171008-pg17_oriole
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-19 14:12:27
[INFO] Using version from PR: https://github.com/supabase/postgres/pull/1714
[INFO] Resolved version: 17.6.0.021-orioledb-update-nixpkgs-5
[STEP] Creating project with PostgresEngine 17-oriole...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine 
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-5 | us-east-1 | ami-0c2a7b752b30de150 | ga              | 17-oriole
(1 row)


http://localhost:8082/project/chszhbfsjjycugjxntik
Database status is not yet available, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is currently COMING_UP, waiting...
Database status is now ACTIVE_HEALTHY
[SUCCESS] Project supadev-test-1766171008-pg17_oriole created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 254 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-test-1766171008-pg17_oriole...
error: unrecognized subcommand 'project-health'

  tip: some similar subcommands exist: 'project-upgrade-eligibility', 'project-information', 'project-id'

Usage: supadev <COMMAND>

For more information, try '--help'.
[STEP] Printing project information for supadev-test-1766171008-pg17_oriole
{
  "cloud_provider": "AWS",
  "db_host": "db.chszhbfsjjycugjxntik.supabase.red",
  "id": 7,
  "inserted_at": "2025-12-19T19:12:30.1571",
  "name": "supadev-test-1766171008-pg17_oriole",
  "organization_id": 1,
  "ref": "chszhbfsjjycugjxntik",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "4UBPqvTF5gpecaCB",
  "connectionString": "U2FsdGVkX195fa9o3nS65pT/tfhj25zPja3zCLEDyHYFYNmAKnjEnN7Jm57s9NoyFD9oibm8F4ohDOz0MBAm7taVZNDORY4dnM+xDBPYG58yKN9g2ZL6Pa5B/kZwCX2vhIMReVkkcoclyyvRq1LQPevOLH8rfq/QncS7z5T8te0xlaX9wDcdH2gkNCxab8zJ",
  "restUrl": "https://chszhbfsjjycugjxntik.supabase.red/rest/v1/",
  "volumeSizeGb": 8,
  "maxDatabasePreprovisionGb": null,
  "lastDatabaseResizeAt": null,
  "is_branch_enabled": false,
  "is_physical_backups_enabled": false,
  "infra_compute_size": "nano",
  "dbVersion": "17.6.0.021-orioledb-update-nixpkgs-5"
}
[STEP] Deleting project supadev-test-1766171008-pg17_oriole...
Project deleted
[SUCCESS] Project supadev-test-1766171008-pg17_oriole deleted successfully
[SUCCESS] PostgresEngine 17-oriole test completed successfully
[INFO] Total test duration: 265 seconds


============================================================
Cleaning Up: Withdrawing Inserted Versions
============================================================
[STEP] Withdrawing version 15.14.1.064-update-nixpkgs-5 for engine 15...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                     |  region   |   provider_image_id   | release_channel | postgres_engine 
------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-15.14.1.064-update-nixpkgs-5 | us-east-1 | ami-039caa3662c5f0532 | withdrawn       | 15
(1 row)


[SUCCESS] Version 15.14.1.064-update-nixpkgs-5 marked as withdrawn
[STEP] Withdrawing version 17.6.1.064-update-nixpkgs-5 for engine 17...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                    version                    |  region   |   provider_image_id   | release_channel | postgres_engine 
-----------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn       | 17
(1 row)


[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 marked as withdrawn
[STEP] Withdrawing version 17.6.0.021-orioledb-update-nixpkgs-5 for engine 17-oriole...
🧐 🐘 postgres_dba 6.0 installed. Use ":dba" to see menu
INSERT 0 0
UPDATE 1
                        version                         |  region   |   provider_image_id   | release_channel | postgres_engine 
--------------------------------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.0.021-orioledb-update-nixpkgs-5 | us-east-1 | ami-0c2a7b752b30de150 | withdrawn       | 17-oriole
(1 row)


[SUCCESS] Version 17.6.0.021-orioledb-update-nixpkgs-5 marked as withdrawn

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (330s)
17              PASSED (209s)
17-oriole       PASSED (265s)

============================================================
Total: 3 | Passed: 3 | Failed: 0
============================================================

Dec 19 '25 20:12 samrose

Walkthrough

Multiple Nix/flake/input updates, platform resolution switched to hostPlatform.system, Darwin-specific dependencies removed, passthru/test API extended (lib_name, installedExtensions, withJIT/withoutJIT), cargo-pgrx gains an optional rustc wrapper, schema_migrations.version length restriction relaxed, and three Postgres release strings bumped.

Changes

Cohort / File(s)	Summary
Ansible version bumps `ansible/vars.yml`	Bumped three `postgres_release` entries to `*-update-nixpkgs-6` variants (`postgresorioledb-17`, `postgres17`, `postgres15`).
Flake inputs & overlays `flake.nix`, `nix/nixpkgs.nix`, `nix/overlays/default.nix`	Replaced single nixpkgs input with multiple pinned/aux inputs (flake-parts, git-hooks.nix, nix2container, nixpkgs-oldstable, etc.), added follow relationships, and introduced an overlay exposing `curl_8_6`/`v8_oldstable`.
Schema migrations `migrations/schema-15.sql`, `migrations/schema-17.sql`, `migrations/schema-orioledb-17.sql`	Relaxed `public.schema_migrations.version` column from `character varying(128) NOT NULL` → `character varying NOT NULL`.
cargo-pgrx changes `nix/cargo-pgrx/*` (e.g., `buildPgrxExtension.nix`, `default.nix`, `versions.json`, `mkPgrxExtension.nix`)	Removed Darwin-specific inheritance/inputs, introduced conditional rustc wrapper for cargo-pgrx < 0.12.0, switched many callsites to use `stdenv.hostPlatform.system`, and updated cargo hashes.
Platform refactor: hostPlatform.system many under `nix/ext/tests/.nix`, `nix/packages/`, `nix/packages/...`	Replaced `pkgs.system` / `system` with `pkgs.stdenv.hostPlatform.system` / `stdenv.hostPlatform.system` across numerous packages and tests to resolve host-platform variants.
Extension tests: passthru & API `nix/ext/tests/*.nix`, `nix/ext/tests/lib.py`, `nix/ext/tests/default.nix`	Added `passthru.installedExtensions`, `passthru.withJIT`, `passthru.withoutJIT` to many `postgresqlWithExtension` outputs; extended `PostgresExtensionTest.__init__` to accept optional `lib_name` and updated checks to use it.
plv8 / v8 selection & overlays `nix/ext/plv8/default.nix`, `nix/nixpkgs.nix`	Introduced `v8_oldstable` input and per-version v8 selection; reorganized build/link flags and patchelf handling.
timescaledb loader & passthru `nix/ext/timescaledb.nix`, `nix/ext/tests/timescaledb.nix`	Added loader symlink alias and `passthru.libName = "timescaledb-loader"`; tests updated to pass schema and loader lib_name.
pgrouting PG17 compatibility `nix/ext/pgrouting/*`	Added conditional patch fixing DatumGetCString usage for PG17, adjusted CMake flags and conditional patch application.
Groonga / sfcgal rework `nix/packages/groonga/*`, `nix/packages/sfcgal.nix`, `nix/packages/default.nix`	Removed vendored libraries from groonga, fixed CMake install paths, deleted `sfcgal` derivation, and moved `supabase-groonga` to `../ext/pgroonga/groonga.nix`.
Wrappers, Go, and Darwin cleanup `nix/ext/wrappers/default.nix`, `nix/packages/packer.nix`, `nix/packages/supascan.nix`	Removed many Darwin-specific framework deps, simplified Go build overrides, set `env.CGO_ENABLED = "0"` for supascan, and removed Darwin-only inputs.
Minor refactors & formatting `nix/ext/gdal.nix`, `nix/ext/pgaudit.nix`, `nix/ext/pgroonga/*`, `nix/ext/vault.nix`, `nix/ext/wal2json.nix`, `nix/checks.nix`, `testinfra/test_ami_nix.py`	Mostly formatting, small signature tweaks (e.g., `rev` → `_rev`), reflowed blocks, and assertion formatting changes.
lib.nix & packaging substitutions `nix/packages/lib.nix`, `nix/packages/dbmate-tool.nix`, `nix/packages/show-commands.nix`	Switched substitution keys and packaging lookups to `stdenv.hostPlatform.system`, added safer copy/error checks, and updated function signatures to accept `stdenv`.
Sync & tooling versions `nix/packages/sync-exts-versions.nix`, `flake.nix`	Updated nixVersions usage and flake input URLs to channel tarballs / pinned commits.
Removed files `nix/packages/sfcgal.nix`	Deleted `sfcgal` derivation file.

Sequence Diagram(s)

(omitted)

Estimated code review effort

🎯 4 (Complex) | ⏱️ ~60 minutes

Possibly related PRs

supabase/postgres#1952 — Updates the same ansible/vars.yml Postgres release entries (postgresorioledb-17, postgres17, postgres15).

Suggested reviewers

LGUG2Z
samrose
darora

Poem

"🐰 I hopped through flakes and changed the pins,
removed a few Mac-only fins.
Tests now know the lib name's song,
loaders linked and hashes strong.
A carrot for each green build win!"

Pre-merge checks

❌ Failed checks (1 inconclusive)

Check name	Status	Explanation	Resolution
Description check	❓ Inconclusive	The PR description is minimal and vague. While it mentions updating nixpkgs and provides two commit hashes, it lacks the structured information required by the repository's template.	Follow the repository's PR description template (either Default or Extension Upgrade). Include context on why this update was made, what nixpkgs version provides, testing performed, and any breaking changes or migration notes.

✅ Passed checks (2 passed)

Check name	Status	Explanation
Title check	✅ Passed	The title 'Update nixpkgs' is directly related to the main change in the PR—updating nixpkgs input to a more recent version—but lacks specificity about the nature of this update.
Docstring Coverage	✅ Passed	Docstring coverage is 90.91% which is sufficient. The required threshold is 80.00%.

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

_{Comment @coderabbitai help to get the list of available commands and usage tips.}

Jan 05 '26 17:01 coderabbitai[bot]

The engines smoke test which brings up a Supabase project with each Postgres engine at the AMI versions in this PR and then runs the engine-appropriate tests from nix/tests against them all passed

❯ ./scripts/test-postgres-engines-with-smoke.sh https://github.com/supabase/postgres/pull/1714

============================================================
Supadev PostgreSQL Engine Smoke Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17 17-oriole
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-engine-smoke-1767735965
[INFO] Cache directory: /Users/lgug2z/.cache/supadev/postgres
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714

[STEP] Resolving postgres commit hash...
[SUCCESS] Using postgres commit: fa26b67c6e367b8b147ba27f79f763a5fe0e6ce8
[SUCCESS] Using cached postgres repo at fa26b67c
[INFO] Found 62 SQL test files

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (379s)
17              PASSED (360s)
17-oriole       PASSED (415s)

============================================================
Total: 3 | Passed: 3 | Failed: 0
============================================================
[INFO] Postgres commit: fa26b67c6e367b8b147ba27f79f763a5fe0e6ce8
[INFO] Cache location: /Users/lgug2z/.cache/supadev/postgres/fa26b67c6e367b8b147ba27f79f763a5fe0e6ce8
[SUCCESS] All tests passed!

The pause/restore smoke tests which bring up a Supabase project, pause it (taking a backup, retiring the VM), and then restore it (to a new VM, restoring the backup) for every Postgres engine all passed.

❯ ./scripts/test-postgres-pause-restore.sh https://github.com/supabase/postgres/pull/1714

============================================================
Supadev PostgreSQL Pause/Restore Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17 17-oriole
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-pause-1767744640
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (686s)
17              PASSED (869s)
17-oriole       PASSED (806s)

============================================================
Total: 3 | Passed: 3 | Failed: 0
============================================================
[SUCCESS] All tests passed!

The 15->17 and 17->17 upgrade smoke tests both passed (output truncated)

❯ ./scripts/test-postgres-upgrade-with-smoke.sh https://github.com/supabase/postgres/pull/1714

============================================================
Supadev PostgreSQL Smoke Upgrade Test Suite
============================================================
[INFO] Testing PostgresEngines: 15 17
[INFO] Using region: us-east-1
[INFO] Project prefix: supadev-upgrade-smoke-1767748118
[INFO] SQL smoke directory: /Users/lgug2z/supadev/sql/smoke
[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714

============================================================
Testing PostgreSQL Smoke Upgrade: 15
============================================================
[INFO] Project name: supadev-upgrade-smoke-1767748118-pg15
[INFO] Region: us-east-1
[INFO] Start time: 2026-01-06 17:08:38
[SUCCESS] Resolved version: 17.6.1.067-update-nixpkgs-6
[STEP] Creating project with PostgresEngine 15 (ensuring version < 17.6.1.067-update-nixpkgs-6)...
Creating project on release channel "ga" with version "supabase-postgres-15.14.1.063"
[STEP] Printing project information before upgrade...
{
  "dbVersion": "supabase-postgres-15.14.1.063"
}

[SUCCESS] Version 17.6.1.067-update-nixpkgs-6 inserted as GA
[STEP] Printing project upgrade eligibility...
{
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.067-update-nixpkgs-6"
    }
  ],
}
[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.067-update-nixpkgs-6...
[STEP] Printing project information after upgrade...
{
  "dbVersion": "supabase-postgres-17.6.1.067-update-nixpkgs-6"
}

[SUCCESS] Version 17.6.1.067-update-nixpkgs-6 marked as withdrawn
[SUCCESS] PostgresEngine 15 smoke upgrade test completed successfully
[INFO] Total test duration: 1180 seconds

============================================================
Testing PostgreSQL Smoke Upgrade: 17
============================================================
[INFO] Project name: supadev-upgrade-smoke-1767748118-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2026-01-06 17:28:18
[SUCCESS] Resolved version: 17.6.1.067-update-nixpkgs-6
[STEP] Creating project with PostgresEngine 17 (ensuring version < 17.6.1.067-update-nixpkgs-6)...
Creating project on release channel "ga" with version "supabase-postgres-17.6.1.063"
[STEP] Printing project information before upgrade...
{
  "dbVersion": "supabase-postgres-17.6.1.063"
}

[SUCCESS] Version 17.6.1.067-update-nixpkgs-6 inserted as GA
[STEP] Printing project upgrade eligibility...
{
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.067-update-nixpkgs-6"
    }
  ],
}
[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.067-update-nixpkgs-6...
[STEP] Printing project information after upgrade...
{
  "dbVersion": "supabase-postgres-17.6.1.067-update-nixpkgs-6"
}

[SUCCESS] Version 17.6.1.067-update-nixpkgs-6 marked as withdrawn
[SUCCESS] PostgresEngine 17 smoke upgrade test completed successfully
[INFO] Total test duration: 653 seconds

============================================================
Test Summary
============================================================

ENGINE          RESULT
------          ------
15              PASSED (1180s)
17              PASSED (653s)

============================================================
Total: 2 | Passed: 2 | Failed: 0
============================================================
[SUCCESS] All tests passed!

Jan 06 '26 22:01 LGUG2Z