2026-10-06 18:38:10 [INFO] Starting HTTP mock server (will find free port)... 2026-10-06 18:38:11 [INFO] HTTP mock server started on port 8880 2026-10-06 18:38:11 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ShNtjpUp1a 2026-10-06 18:38:11 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-10-06 18:38:11 [INFO] Checking shared_preload_libraries setting: 2026-10-06 18:38:11 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-10-06 18:38:11 [INFO] Configuring local auth 2026-10-06 18:38:11 [INFO] Waiting for PostgreSQL to be ready... 2026-10-06 18:38:11 [INFO] PostgreSQL is ready 2026-10-06 18:38:11 [INFO] Creating test database 2026-10-06 18:38:12 [INFO] CLI variant detected - loading CLI prime SQL file 2026-10-06 18:38:12 [INFO] Creating test_config table 2026-10-06 18:38:12 [INFO] Running pgtap test: auth.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: create_statistics_priv.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: dblink.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-array-test.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-cascades-deletes.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-connections.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-enums.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-full-text-search.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-functions.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-indexes.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-json.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-partitioning.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-tables-and-data.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-triggers.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-webhooks.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: enable_tracking.sql 2026-10-06 18:38:12 [INFO] Running pgtap test: intarray_ltree_query.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: ltree_label_overflow.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: multirange_create_priv.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: operator_breaking_change.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pg-safeupdate.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_graphql.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_net.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_plan_filter.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pgaudit.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pgbouncer.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: pgsodium.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: realtime.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: replica_identity_upsert.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: storage.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: supautils_reserved_roles.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: vault.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: wal2json.sql 2026-10-06 18:38:13 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql 2026-10-06 18:38:14 [INFO] Starting PostgreSQL server for pg_regress tests 2026-10-06 18:38:17 [INFO] PostgreSQL is ready 2026-10-06 18:38:17 [INFO] CLI variant detected - loading CLI prime SQL file 2026-10-06 18:38:17 [ERROR] Error executing CLI prime SQL file 2026-10-06 18:38:17 [ERROR] An error occurred. Exit code: 1 2026-10-06 18:38:17 [ERROR] Debug logs: 2026-10-06 18:38:10 [INFO] Starting HTTP mock server (will find free port)... $ /nix/store/qzc04a3npl70cyyy6flnnrb2ig3kayxm-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py 2026-10-06 18:38:11 [INFO] HTTP mock server started on port 8880 2026-10-06 18:38:11 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ShNtjpUp1a $ initdb --locale=C --username=supabase_admin -D /build/tmp.ShNtjpUp1a The files belonging to this database system will be owned by user "nixbld". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /build/tmp.ShNtjpUp1a ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: pg_ctl -D /build/tmp.ShNtjpUp1a -l logfile start 2026-10-06 18:38:11 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-10-06 18:38:11 [INFO] Checking shared_preload_libraries setting: 2026-10-06 18:38:11 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-10-06 18:38:11 [INFO] Configuring local auth $ pg_ctl -D /build/tmp.ShNtjpUp1a -l /build/tmp.ShNtjpUp1a/postgresql.log -o -k /build/tmp.ShNtjpUp1a/sockets -p 5541 -d 5 start waiting for server to start.... done server started 2026-10-06 18:38:11 [INFO] Waiting for PostgreSQL to be ready... $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-10-06 18:38:11 [INFO] PostgreSQL is ready 2026-10-06 18:38:11 [INFO] Creating test database $ createdb -p 5541 -h localhost --username=supabase_admin testing 2026-10-06 18:38:12 [INFO] CLI variant detected - loading CLI prime SQL file $ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql SET CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION 2026-10-06 18:38:12 [INFO] Creating test_config table $ psql -p 5541 -h localhost --username=supabase_admin -d testing -c CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT); INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; CREATE TABLE INSERT 0 1 INSERT 0 1 2026-10-06 18:38:12 [INFO] Running pgtap test: auth.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/auth.sql schema_name | owner -------------+------- (0 rows) schema_name | table_name | owner | rls_enabled | rls_policies -------------+------------+-------+-------------+-------------- (0 rows) schema_name | table_name | role_name | privilege_type | is_grantable -------------+------------+-----------+----------------+-------------- (0 rows) table_schema | table_name | index_name | index_owner --------------+------------+------------+------------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist LINE 1: select * from auth.schema_migrations; ^ 2026-10-06 18:38:12 [INFO] Running pgtap test: create_statistics_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:12 [INFO] Running pgtap test: dblink.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql SET DROP EXTENSION psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql:10: ERROR: role "postgres" does not exist CREATE TABLE CREATE EXTENSION DROP TABLE RESET function_name | grantee | privilege_type -----------------------------+----------------+---------------- dblink_connect_u(text) | supabase_admin | EXECUTE dblink_connect_u(text,text) | supabase_admin | EXECUTE (2 rows) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql:28: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) DROP EXTENSION CREATE EXTENSION 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-array-test.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-array-test.sql CREATE TABLE INSERT 0 1 id | textarray ----+------------------- 1 | {Harry,Larry,Moe} (1 row) textarray | array_length -----------+-------------- Harry | 3 (1 row) DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-cascades-deletes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:47: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE ALTER TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:80: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE ALTER TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:113: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE UPDATE 1 DELETE 1 count ------- 0 (1 row) count ------- 0 (1 row) count ------- 0 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 DELETE 1 count ------- 0 (1 row) count ------- 0 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:186: ERROR: update or delete on table "test_restrict" violates foreign key constraint "test_restrict_child_parent_id_fkey" on table "test_restrict_child" DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child". count ------- 1 (1 row) count ------- 1 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 DELETE 1 count ------- 0 (1 row) count ------- 1 (1 row) parent_id ----------- (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:225: ERROR: insert or update on table "test_set_default_child" violates foreign key constraint "test_set_default_child_parent_id_fkey" DETAIL: Key (parent_id)=(999) is not present in table "test_set_default". count ------- 1 (1 row) count ------- 1 (1 row) parent_id ----------- 1 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:245: ERROR: update or delete on table "test_no_action" violates foreign key constraint "test_no_action_child_parent_id_fkey" on table "test_no_action_child" DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child". count ------- 1 (1 row) count ------- 1 (1 row) DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-connections.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-connections.sql ssl | database | connected_role | application_name | query | state -----+----------+----------------+------------------+--------------------------------------------+-------- f | testing | supabase_admin | psql | select +| active | | | | ssl, +| | | | | datname as database, +| | | | | usename as connected_role, +| | | | | application_name, +| | | | | query, +| | | | | state +| | | | | from pg_stat_ssl +| | | | | join pg_stat_activity +| | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | (1 row) 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-enums.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-enums.sql CREATE TYPE CREATE TABLE INSERT 0 1 INSERT 0 1 INSERT 0 1 id | name | current_mood ----+------+-------------- 2 | Bob | sad (1 row) id | name | current_mood ----+-------+-------------- 1 | Alice | happy (1 row) UPDATE 1 id | name | current_mood ----+-------+-------------- 1 | Alice | excited (1 row) ALTER TYPE INSERT 0 1 enum_range ---------------------------------- {happy,sad,excited,calm,content} (1 row) id | name | current_mood ----+-------+-------------- 4 | David | content (1 row) CREATE TYPE CREATE TABLE INSERT 0 3 id | order_number | status ----+--------------+-------- 1 | ORD-001 | active (1 row) UPDATE 1 id | order_number | status ----+--------------+---------- 2 | ORD-002 | inactive (1 row) ALTER TYPE INSERT 0 1 enum_range ------------------------------------- {active,inactive,pending,cancelled} (1 row) id | order_number | status ----+--------------+----------- 4 | ORD-004 | cancelled (1 row) CREATE TYPE CREATE TABLE INSERT 0 3 id | title | priority ----+----------------+---------- 3 | Security audit | critical (1 row) UPDATE 1 id | title | priority ----+-------------+---------- 2 | Update docs | medium (1 row) ALTER TYPE INSERT 0 1 enum_range ----------------------------------- {low,medium,high,critical,urgent} (1 row) id | title | priority ----+--------------------+---------- 4 | Server maintenance | urgent (1 row) DROP TABLE DROP TABLE DROP TABLE DROP TYPE DROP TYPE DROP TYPE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-full-text-search.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-full-text-search.sql CREATE TABLE INSERT 0 5 to_tsvector --------------------------- 'egg':2 'green':1 'ham':4 (1 row) to_tsvector --------------------------- 'egg':2 'green':1 'ham':4 (1 row) id | title | author | description ----+-------+--------+------------- (0 rows) id | title | author | description ----+-------------------------------------+--------------+------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (1 row) id | title | author | description ----+-------------------------------------+-------------------+------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (2 rows) id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (2 rows) CREATE FUNCTION id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (2 rows) id | title | author | description ----+--------+-------------------+---------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (1 row) id | title | author | description ----+-------------------------------------+-------------------+------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (2 rows) title ----------------------- The Poky Little Puppy (1 row) CREATE FUNCTION id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. (1 row) id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. (1 row) ALTER TABLE CREATE INDEX id | fts ----+----------------------------------------------------------------------------------------------------------------- 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (5 rows) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (1 row) id | title | author | description | fts ----+--------------------+-----------+--------------------------------------------------------------------+--------------------------------------------------------------------------------------------------- 4 | Green Eggs and Ham | Dr. Seuss | Sam has changing food preferences and eats unusually colored food. | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8 (1 row) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+-------+--------+-------------+----- (0 rows) id | title | author | description | fts ----+--------------------------+----------------+------------------------------+--------------------------------------------------- 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (1 row) id | title | author | description | fts ----+-------+--------+-------------+----- (0 rows) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) DROP FUNCTION DROP FUNCTION DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-functions.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql CREATE FUNCTION hello_world ------------- hello world (1 row) CREATE TABLE INSERT 0 3 CREATE TABLE INSERT 0 4 CREATE FUNCTION id | name ----+---------- 1 | Tattoine (1 row) CREATE FUNCTION psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey" DETAIL: Key (id)=(1) already exists. CONTEXT: SQL statement "insert into planets(name) values (add_planet.name) returning id" PL/pgSQL function add_planet(text) line 5 at SQL statement CREATE FUNCTION hello_world_definer --------------------- hello world (1 row) REVOKE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:79: ERROR: role "anon" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist REVOKE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:84: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:87: ERROR: role "anon" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist CREATE FUNCTION psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE CREATE FUNCTION error_if_null --------------- not null (1 row) CREATE TABLE INSERT 0 1 CREATE FUNCTION assert_example -------------------------------------- 123e4567-e89b-12d3-a456-426614174000 (1 row) CREATE FUNCTION psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:162: ERROR: An error occurred in function : relation "table_that_does_not_exist" does not exist CONTEXT: PL/pgSQL function error_example() line 7 at RAISE CREATE TABLE INSERT 0 1 CREATE FUNCTION advanced_example ------------------ 42,new val (1 row) DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE GRANT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:221: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:224: ERROR: role "anon" does not exist 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-indexes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-indexes.sql CREATE TABLE INSERT 0 1 name ---------- John Doe (1 row) CREATE INDEX CREATE INDEX CREATE INDEX REINDEX REINDEX DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-json.sql CREATE TABLE INSERT 0 5 title | description | price | low_age | high_age -------------------------------------+--------------------------------------------------------------------+-------+---------+---------- The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99 (5 rows) DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-partitioning.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-partitioning.sql CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 4 id | order_date | customer_id | amount ----+------------+-------------+-------- 1 | 2000-01-15 | 1 | 100 2 | 2000-01-20 | 2 | 200 3 | 2000-02-10 | 3 | 150 4 | 2000-02-25 | 4 | 300 (4 rows) id | order_date | customer_id | amount ----+------------+-------------+-------- 3 | 2000-02-10 | 3 | 150 4 | 2000-02-25 | 4 | 300 (2 rows) DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 5 id | name | country ----+------------+--------- 1 | John Doe | US 2 | Jane Smith | CANADA (2 rows) id | name | country ----+-------------+--------- 3 | Li Wei | CHINA 4 | Priya Patel | INDIA 5 | Yuki Tanaka | JAPAN (3 rows) DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 4 id | name | category | price ----+--------+-------------+------- 1 | Laptop | Electronics | 999 2 | Phone | Electronics | 599 (2 rows) count ------- 2 (1 row) count ------- 2 (1 row) DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-tables-and-data.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql CREATE TABLE table_name | column_name | data_type | is_nullable | column_default ------------+-------------+-----------+-------------+---------------- movies | id | bigint | NO | movies | name | text | YES | movies | description | text | YES | (3 rows) DROP TABLE CREATE TABLE column_name | data_type | is_nullable | column_default | is_identity | identity_generation -------------+-----------+-------------+----------------+-------------+--------------------- id | bigint | NO | | YES | ALWAYS (1 row) DROP TABLE CREATE TABLE column_name | data_type | is_nullable | column_default | is_identity | identity_generation -------------+-----------+-------------+----------------+-------------+--------------------- id | bigint | NO | | YES | BY DEFAULT (1 row) DROP TABLE CREATE TABLE INSERT 0 2 id | name | description ----+-------------------------+-------------------------------------------------------------------------------------------------------------------------------- 1 | The Empire Strikes Back | After the Rebels are brutally overpowered by the Empire on the ice planet Hoth, Luke Skywalker begins Jedi training with Yoda. 2 | Return of the Jedi | After a daring mission to rescue Han Solo from Jabba the Hutt, the Rebels dispatch to Endor to destroy the second Death Star. (2 rows) DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping DROP TABLE CREATE TABLE CREATE TABLE ALTER TABLE table_name | column_name | foreign_table_name | foreign_column_name ------------+-------------+--------------------+--------------------- movies | category_id | categories | id (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping DROP TABLE DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE table_name -------------- actors movies performances (3 rows) CREATE SCHEMA schema_name ------------- private (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances DROP TABLE CREATE TABLE CREATE TABLE table_schema | table_name --------------+------------ private | salaries (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping DROP TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping DROP VIEW CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 3 INSERT 0 3 INSERT 0 6 CREATE VIEW psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist name | type | title | code | result ------------------+---------------+--------------------------+---------+-------- Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A- Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B- Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+ Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+ Yoda | graduate | Authentication Theories | AUTH205 | A (6 rows) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping DROP MATERIALIZED VIEW SELECT 6 name | type | title | code | result ------------------+---------------+--------------------------+---------+-------- Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A- Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B- Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+ Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+ Yoda | graduate | Authentication Theories | AUTH205 | A (6 rows) REFRESH MATERIALIZED VIEW count ------- 6 (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping DROP VIEW CREATE VIEW schemaname | viewname ------------+-------------------- public | secure_transcripts (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping DROP VIEW CREATE VIEW ALTER VIEW schemaname | viewname ------------+----------- public | test_view (1 row) DROP MATERIALIZED VIEW DROP VIEW DROP VIEW DROP VIEW DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP SCHEMA 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-triggers.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-triggers.sql CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 UPDATE 1 id | employee_id | old_salary | new_salary ----+-------------+------------+------------ 1 | 1 | 50000 | 55000 (1 row) CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 DELETE 1 id | customer_id | action | customer_name ----+-------------+--------+--------------- 1 | 1 | DELETE | Alice Johnson (1 row) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 id | trigger_name | operation | table_name ----+-------------------------+-----------+------------ 1 | statement_level_trigger | INSERT | orders (1 row) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 UPDATE 1 DELETE 1 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id ----+-------------------+--------------+-----------+------------+--------------+-------- 1 | variables_trigger | AFTER | INSERT | employees | public | 3 2 | variables_trigger | AFTER | UPDATE | employees | public | 3 3 | variables_trigger | AFTER | DELETE | employees | public | 3 (3 rows) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | employee_name | salary ----+---------------+-------- 1 | Executive | 150000 (1 row) DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: docs-webhooks.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-webhooks.sql CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER CREATE TRIGGER CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | webhook_name | event_type | table_name | schema_name | ?column? ----+----------------+------------+------------+-------------+-------------------------------------------------------------- 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"} 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"} (2 rows) UPDATE 1 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? ----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------ 3 | update_webhook | UPDATE | profiles | public | {"id": 1, "name": "John Doe", "email": "john.doe@example.com"} | {"id": 1, "name": "John Doe", "email": "john@example.com"} (1 row) DELETE 1 id | webhook_name | event_type | table_name | schema_name | ?column? ----+----------------+------------+------------+-------------+-------------------------------------------------------------- 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"} (1 row) CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | webhook_name | url | method | response_status | response_data ----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------ 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"} 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"} (2 rows) CREATE TABLE INSERT 0 1 CREATE FUNCTION CREATE TRIGGER INSERT 0 1 id | webhook_name | url | method | response_status | response_data ----+-----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------- 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"} (1 row) CREATE FUNCTION webhook_name | event_type | table_name | record_count ----------------+------------+------------+-------------- delete_webhook | DELETE | profiles | 1 insert_webhook | INSERT | profiles | 3 update_webhook | UPDATE | profiles | 1 (3 rows) DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-06 18:38:12 [INFO] Running pgtap test: enable_tracking.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist 2026-10-06 18:38:12 [INFO] Running pgtap test: intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql BEGIN SET CREATE EXTENSION CREATE EXTENSION q_and ------- f (1 row) q_or ------ t (1 row) lquery_match -------------- t (1 row) ltxtquery_match ----------------- t (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: ltree_label_overflow.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/ltree_label_overflow.sql BEGIN SET CREATE EXTENSION na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a -------+----+--------+--------+--------+-------- 20001 | 1 | t | f | t | t (1 row) ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: multirange_create_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: operator_breaking_change.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql BEGIN SET CREATE EXTENSION CREATE SCHEMA psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: pg-safeupdate.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql LOAD SET CREATE SCHEMA CREATE TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_graphql.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_graphql.sql BEGIN COMMENT CREATE TABLE CREATE TABLE COMMENT CREATE FUNCTION resolve ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {"data": {"insertIntoAccountCollection": {"records": [{"id": 1, "status": "active", "echoEmail": "foo@barsley.com", "blogCollection": {"totalCount": 0}}, {"id": 2, "status": "active", "echoEmail": "bar@foosworth.com", "blogCollection": {"totalCount": 0}}], "affectedCount": 2}}} (1 row) resolve -------------------------------------------------------------------------------------- {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}} (1 row) resolve ------------------------------------------------------------------------------------------------------------------------ {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}} (1 row) resolve -------------------------------------------------------------------------------------------------------------------------------- {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}} (1 row) resolve ------------------------------------------------------------------------------------------------ {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}} (1 row) resolve ------------------------------------------------------------------------------------------------ {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}} (1 row) resolve ----------------------------------------------------------------------------------------------------------------- {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}} (1 row) resolve ----------------------------------------------------------------------------------------------------------------- {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}} (1 row) resolve -------------------------------------------------------------- {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}} (1 row) resolve --------------------------------------------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]} (1 row) resolve ----------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]} (1 row) resolve --------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]} (1 row) resolve -------------------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]} (1 row) ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_net.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_net.sql request_id ------------ 1 (1 row) 2026-10-06 18:38:13 [INFO] Running pgtap test: pg_plan_filter.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql BEGIN psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: pgaudit.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgaudit.sql SET SET SET CREATE SCHEMA CREATE TABLE INSERT 0 1 id | name | password | description ----+-------+----------+------------- 1 | user1 | HASH1 | blah, blah (1 row) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account DROP SCHEMA 2026-10-06 18:38:13 [INFO] Running pgtap test: pgbouncer.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql schema_name | owner -------------+------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) schema | object_name | grantee | privilege_type --------+-------------+---------+---------------- (0 rows) CREATE ROLE CREATE ROLE UPDATE 1 psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:61: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_expired_user_password'); ^ psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:63: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:66: ERROR: role "pgbouncer" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:67: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:71: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:72: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET DROP ROLE DROP ROLE 2026-10-06 18:38:13 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql BEGIN CREATE EXTENSION SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK aes128_rt ----------- secret (1 row) aes192_rt ----------- secret (1 row) aes256_rt ----------- secret (1 row) des3_rt --------- secret (1 row) SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data ROLLBACK SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data ROLLBACK post_error_ok --------------- still-here (1 row) ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: pgsodium.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgsodium.sql status -------- valid (1 row) 2026-10-06 18:38:13 [INFO] Running pgtap test: realtime.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/realtime.sql publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate ------------------+-------+--------------+-----------+-----------+-----------+------------- (0 rows) 2026-10-06 18:38:13 [INFO] Running pgtap test: replica_identity_upsert.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql BEGIN CREATE TABLE CREATE PUBLICATION INSERT 0 1 SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. ROLLBACK SAVEPOINT psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. ROLLBACK ALTER TABLE INSERT 0 1 MERGE 1 v ---- 30 (1 row) ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: storage.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql schema_name | owner -------------+------- (0 rows) schema_name | table_name | owner | rls_enabled | rls_policies -------------+------------+-------+-------------+-------------- (0 rows) schema_name | table_name | role_name | privilege_type | is_grantable -------------+------------+-----------+----------------+-------------- (0 rows) table_schema | table_name | index_name | index_owner --------------+------------+------------+------------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) CREATE ROLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:98: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:100: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:101: ERROR: schema "storage" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:102: ERROR: schema "storage" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:104: ERROR: role "postgres" does not exist DROP OWNED DROP ROLE RESET 2026-10-06 18:38:13 [INFO] Running pgtap test: supautils_reserved_roles.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql BEGIN psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-06 18:38:13 [INFO] Running pgtap test: vault.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql schema | object_name | grantee | privilege_type --------+---------------------------+----------------+---------------- vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE vault | create_secret | supabase_admin | EXECUTE vault | update_secret | supabase_admin | EXECUTE (5 rows) schema | table | index_name | index_owner | index_type --------+---------+------------------+----------------+------------ vault | secrets | secrets_name_idx | supabase_admin | Unique vault | secrets | secrets_pkey | supabase_admin | Unique (2 rows) search_path ----------------- "$user", public (1 row) SET DROP EXTENSION CREATE TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql:65: ERROR: role "postgres" does not exist LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'... ^ CREATE EXTENSION DROP TABLE RESET function_name | grantee | privilege_type ---------------+---------+---------------- (0 rows) psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql:83: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) 2026-10-06 18:38:13 [INFO] Running pgtap test: wal2json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql CREATE SCHEMA CREATE TABLE psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory INSERT 0 1 psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-10-06 18:38:13 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql BEGIN SET CREATE EXTENSION psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large DETAIL: Total size of level exceeds the maximum allowed (65535 bytes). psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK $ pg_ctl -D /build/tmp.ShNtjpUp1a stop waiting for server to shut down.... done server stopped 2026-10-06 18:38:14 [INFO] Starting PostgreSQL server for pg_regress tests $ /nix/store/c8nrmj3fwsxsgv3n02hxk84cw2lb4ygp-start-postgres-server-test/bin/start-postgres-server 17 --daemonize Starting server for PSQL 17 /nix/store/c8nrmj3fwsxsgv3n02hxk84cw2lb4ygp-start-postgres-server-test/bin/start-postgres-server: line 190: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8): No such file or directory KEY_FILE: /build/tmp.s7o1qtdArr/pgsodium.key KEY_FILE contents: cat: /build/tmp.s7o1qtdArr/pgsodium.key: No such file or directory PGSODIUM_GETKEY_SCRIPT: /nix/store/hm49fhplcc21kvjqvmyqk4wj50cqqmkx-pgsodium-getkey/bin/pgsodium-getkey NOTE: using port 5541 for server NOTE: using temporary directory /build/tmp.s7o1qtdArr for data NOTE: you are free to re-use this data directory at will The files belonging to this database system will be owned by user "nixbld". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /build/tmp.s7o1qtdArr ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.s7o1qtdArr -l logfile start NOTE: patching postgresql.conf files non-macos pg 17 conf waiting for server to start.... done server started pg_ctl: server is running (PID: 1142) /nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.s7o1qtdArr" "--config-file=/build/tmp.s7o1qtdArr/postgresql.conf" "-p" "5541" "-k" "/build/tmp.s7o1qtdArr/tmp" PostgreSQL is ready psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000000-initial-schema.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000001-auth-schema.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000002-storage-schema.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000003-post-setup.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/10000000000000_demote-postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211115181400_update-auth-permissions.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211118015519_create-realtime-schema.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211122051245_update-realtime-permissions.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211124212715_update-auth-owner.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211130151719_update-realtime-permissions.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220126121436_finer-postgrest-triggers.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220224211803_fix-postgrest-supautils.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220317095840_pg_graphql.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220322085208_gotrue-session-limit.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221028101028_set_authenticator_timeout.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221103090837_revoke_admin.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20241031003909_create_orioledb.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250218031949_pgsodium_mask_role.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250220051611_pg_net_perms_fix.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250312095419_pgbouncer_ownership.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251001204436_predefined_role_grants.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260211120934_supabase_privileged_role.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory PostgreSQL is running in daemon mode. Please stop it using pg_ctl. Shutting down PostgreSQL... PostgreSQL is running in daemon mode. Please stop it using pg_ctl. pg_ctl: another server might be running; trying to start server anyway waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output. pg_ctl: server is running (PID: 1142) /nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.s7o1qtdArr" "--config-file=/build/tmp.s7o1qtdArr/postgresql.conf" "-p" "5541" "-k" "/build/tmp.s7o1qtdArr/tmp" $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-10-06 18:38:17 [INFO] PostgreSQL is ready 2026-10-06 18:38:17 [INFO] CLI variant detected - loading CLI prime SQL file $ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory 2026-10-06 18:38:17 [ERROR] Error executing CLI prime SQL file 2026-10-06 18:38:17 [ERROR] An error occurred. Exit code: 1 2026-10-06 18:38:17 [ERROR] Debug logs: