postgres fix(setup-postgres.yml): fix missing initdb calls

What kind of change does this PR introduce?

updates initdb calls with checksum flag

What is the current behavior?

missing calls from ansible playbook with checksum flag

What is the new behavior?

updated initdb flags for checksums

Additional context

none

Nov 17 '25 19:11 jchancojr

✅ Tested pause/restore on local infra with supabase-postgres-15.14.1.052-INDATA-211 AMI.

⏱️ Pending upgrade test

Nov 18 '25 18:11 jchancojr

Postgres AMI smoke tests passed:

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

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


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


[STEP] Creating project with PostgresEngine 15...
Project URL: http://localhost:8082/project/jeeqrfqlnfwissdvkkaq
Admin URL: http://localhost:4000/projects?identifier=jeeqrfqlnfwissdvkkaq
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-1766075563-pg15 created and reached ACTIVE_HEALTHY status
[INFO] Time to ACTIVE_HEALTHY: 256 seconds
[INFO] Sleeping for 10 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766075563-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:81b2:15e0:3496:8794",
      "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.jeeqrfqlnfwissdvkkaq.supabase.red",
  "id": 14,
  "inserted_at": "2025-12-18T16:32:48.634295",
  "name": "supadev-smoke-1766075563-pg15",
  "organization_id": 1,
  "ref": "jeeqrfqlnfwissdvkkaq",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1+TV1YZuFyUPsOP4mkzQhaeWX3IJ2VqB0m7t4GltZJhu3/yKoPO/IUKKTPd6VW1bvks/WP0a9c8M6NRBZDxAtVOsc1uqxNA+OuC96md54t4d6oBr11ULtZ8nALsRJUVZD6KNeifN4kfoI2ZPVZvxuHccN6gMt0zMwd2DrzbG8clmN801wX0Tpe+",
  "restUrl": "https://jeeqrfqlnfwissdvkkaq.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 16:37:18.072593+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 as GA...
INSERT 0 0
UPDATE 1
           version            |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064 | us-east-1 | ami-0635895a78d6e6948 | ga              | 17
(1 row)


[SUCCESS] Version 17.6.1.064 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",
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.064"
    },
    {
      "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...
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 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 8_attached_volume_to_upgraded_instance, waiting...
Upgrade status is now 9_completed_upgrade
[SUCCESS] Project supadev-smoke-1766075563-pg15 upgraded successfully
[INFO] Time to complete upgrade: 580 seconds
[INFO] Sleeping for 60 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766075563-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:81b2:15e0:3496:8794",
      "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.jeeqrfqlnfwissdvkkaq.supabase.red",
  "id": 14,
  "inserted_at": "2025-12-18T16:32:48.634295",
  "name": "supadev-smoke-1766075563-pg15",
  "organization_id": 1,
  "ref": "jeeqrfqlnfwissdvkkaq",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX19IQH1ypxbqGP0mUZGXTucqAXxqAhuvlWFetXwiC1tUHUBjNgP/mx4MRj/8LWCt+FZZQGs/iBkGUXQ1cvrb88avkAx/+NiYvQ35SCYDaBU27L/Rq+dSwZn7Mr2GlubHQ0/WhuACSkM1I8xWXt6HmOn9RnHJHBj8IaPHih9iBEuyr7lLD1N1T/JF",
  "restUrl": "https://jeeqrfqlnfwissdvkkaq.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"
}

============================================================
Executing post-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql
[INFO] SQL output:
 send
------
    2
(1 row)
[SUCCESS] Found expected string (line 1): send
[SUCCESS] Found expected string (line 2): 2
[SUCCESS] Verification passed for: 01-pgmq.sql

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 16:37:18.072593+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 16:37:18.072593+00
 CREATE TABLE - public.subitems_2 - public - 2025-12-18 16:47:45.676037+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

[SUCCESS] All post-upgrade SQL files executed and verified successfully
[STEP] Deleting project supadev-smoke-1766075563-pg15...
Project deleted
[SUCCESS] Project supadev-smoke-1766075563-pg15 deleted successfully
[STEP] Withdrawing version 17.6.1.064...
INSERT 0 0
UPDATE 1
           version            |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064 | us-east-1 | ami-0635895a78d6e6948 | withdrawn       | 17
(1 row)


[SUCCESS] Version 17.6.1.064 marked as withdrawn
[SUCCESS] PostgresEngine 15 smoke upgrade test completed successfully
[INFO] Total test duration: 905 seconds


============================================================
Testing PostgreSQL Smoke Upgrade: 17
============================================================
[INFO] Project name: supadev-smoke-1766075563-pg17
[INFO] Region: us-east-1
[INFO] Start time: 2025-12-18 08:47:48
[STEP] Resolving version from PR for upgrade target engine 17...
[SUCCESS] Resolved version: 17.6.1.064
[STEP] Ensuring version 17.6.1.064 is withdrawn...
INSERT 0 0
UPDATE 1
           version            |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064 | us-east-1 | ami-0635895a78d6e6948 | withdrawn       | 17
(1 row)


[STEP] Creating project with PostgresEngine 17...
Project URL: http://localhost:8082/project/yxewmrktudqnfvykresa
Admin URL: http://localhost:4000/projects?identifier=yxewmrktudqnfvykresa
Database status is not yet available, 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-1766075563-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-1766075563-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:81b2:15e0:3496:8794",
      "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.yxewmrktudqnfvykresa.supabase.red",
  "id": 15,
  "inserted_at": "2025-12-18T16:47:51.521957",
  "name": "supadev-smoke-1766075563-pg17",
  "organization_id": 1,
  "ref": "yxewmrktudqnfvykresa",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1+jW1DTOjx79nR2EtyZy/ECNUrmOTT/owTCRGjZDqVLeuY3Pq8w6WiqnJIpLsVuBAOXdqk5NfhOiV4IaP7aRYqFg15gbh+t41FvSRVLOr03I3/cHsT7QnyE1BYXcDZG+Nwp5u0tH9pMdjCjjGLZr+VXMC1iYBujpV63W5mm84NcOHJ9KEvsUT04",
  "restUrl": "https://yxewmrktudqnfvykresa.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 16:50:40.484305+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 as GA...
INSERT 0 0
UPDATE 1
           version            |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064 | us-east-1 | ami-0635895a78d6e6948 | ga              | 17
(1 row)


[SUCCESS] Version 17.6.1.064 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",
  "target_upgrade_versions": [
    {
      "postgres_version": "17",
      "release_channel": "ga",
      "app_version": "supabase-postgres-17.6.1.064"
    }
  ],
  "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...
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 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 7_detached_volume_from_original_instance, waiting...
Upgrade status is now 9_completed_upgrade
[SUCCESS] Project supadev-smoke-1766075563-pg17 upgraded successfully
[INFO] Time to complete upgrade: 541 seconds
[INFO] Sleeping for 60 seconds before checking project health
[STEP] Checking project health for supadev-smoke-1766075563-pg17...
[
  {
    "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:81b2:15e0:3496:8794",
      "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.yxewmrktudqnfvykresa.supabase.red",
  "id": 15,
  "inserted_at": "2025-12-18T16:47:51.521957",
  "name": "supadev-smoke-1766075563-pg17",
  "organization_id": 1,
  "ref": "yxewmrktudqnfvykresa",
  "region": "us-east-1",
  "status": "ACTIVE_HEALTHY",
  "subscription_id": "Avx7DALGCeGDjvVm",
  "connectionString": "U2FsdGVkX1/Lgo5Mb69Pe3roZzacZzYYBcw73JFcht6R+IOJxpOToDqbJJB9MHEvqZDfNzE2PrqcDbUfgxJJoOqlxt8Zf6m5lcNNwV7Hgss8kI2DHXvk3AIKg/+EMbx3OJtxpRgFtEM5gPcOewv8G7RajhhNhcWOTaGHnQAIhNXegcIzfdlmR79/gw3omhpg",
  "restUrl": "https://yxewmrktudqnfvykresa.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"
}

============================================================
Executing post-upgrade SQL files
============================================================
[STEP] Executing SQL: 01-pgmq.sql
[INFO] SQL output:
 send
------
    2
(1 row)
[SUCCESS] Found expected string (line 1): send
[SUCCESS] Found expected string (line 2): 2
[SUCCESS] Verification passed for: 01-pgmq.sql

[STEP] Executing SQL: 02-items.sql
[INFO] SQL output:
                                   name
---------------------------------------------------------------------------
 First
 Second
 CREATE TABLE - public.subitems_1 - public - 2025-12-18 16:50:40.484305+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 16:50:40.484305+00
 CREATE TABLE - public.subitems_2 - public - 2025-12-18 17:00:08.086992+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

[SUCCESS] All post-upgrade SQL files executed and verified successfully
[STEP] Deleting project supadev-smoke-1766075563-pg17...
Project deleted
[SUCCESS] Project supadev-smoke-1766075563-pg17 deleted successfully
[STEP] Withdrawing version 17.6.1.064...
INSERT 0 0
UPDATE 1
           version            |  region   |   provider_image_id   | release_channel | postgres_engine
------------------------------+-----------+-----------------------+-----------------+-----------------
 supabase-postgres-17.6.1.064 | us-east-1 | ami-0635895a78d6e6948 | withdrawn       | 17
(1 row)


[SUCCESS] Version 17.6.1.064 marked as withdrawn
[SUCCESS] PostgresEngine 17 smoke upgrade test completed successfully
[INFO] Total test duration: 742 seconds


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

ENGINE          RESULT
------          ------
15              PASSED (905s)
17              PASSED (742s)

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

Dec 18 '25 17:12 LGUG2Z

Walkthrough

Added the data-checksums flag to PostgreSQL pg_ctl initdb invocations across multiple initialization paths in the Ansible setup playbook. The flag is applied to the general initialization step and stage2_nix initialization for both non-orioleledb and orioleledb branches.

Changes

Cohort / File(s)	Summary
PostgreSQL initdb flag updates `ansible/tasks/setup-postgres.yml`	Added `--data-checksums` flag to three `pg_ctl initdb` invocations: general Init DB step, stage2_nix non-orioleledb path, and stage2_nix orioleledb path. All other arguments and behavior unchanged.

Estimated code review effort

🎯 1 (Trivial) | ⏱️ ~3 minutes

Single file with repetitive, homogeneous changes (adding identical flag across three locations)
Pure configuration modification with no logic changes
No control flow or error handling modifications

Poem

🐰 A checksummed hop through data fields fair,
Three paths now guarded with cryptographic care,
The flag is planted, small but strong,
Where PostgreSQL's mighty roots belong,
Data integrity hops all day long! ✨

Pre-merge checks and finishing touches

❌ Failed checks (1 warning, 1 inconclusive)

Check name	Status	Explanation	Resolution
Title check	⚠️ Warning	The title mentions 'fix missing initdb calls' but the actual change is adding a data-checksums flag to existing initdb invocations, not fixing missing calls.	Update the title to accurately reflect the change, e.g., 'fix(setup-postgres.yml): add data-checksums flag to initdb invocations'.
Description check	❓ Inconclusive	The description covers the basic change (adding checksums flag) but lacks detail about affected locations and doesn't follow the provided template structure.	Follow the repository's PR template structure more closely and provide specific details about which tasks/playbook sections were modified.

✅ Passed checks (1 passed)

Check name	Status	Explanation
Docstring Coverage	✅ Passed	No functions found in the changed files to evaluate docstring coverage. Skipping docstring coverage check.

✨ Finishing touches

🧪 Generate unit tests (beta)

[ ] Create PR with unit tests
[ ] Post copyable unit tests in a comment
[ ] Commit unit tests in branch INDATA-211

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

Dec 19 '25 19:12 coderabbitai[bot]