deepseek/deepseek-v4-pro · d2_backup_restore · rep 3

echo "URL: $SUPABASE_URL" && echo "Ref: $SUPABASE_PROJECT_REF" && echo "DB URL: ${SUPABASE_DB_URL:+set}" && echo "PSQL version:" && psql --version

URL: https://<ref>.supabase.co
Ref: <ref>
DB URL: set
PSQL version:
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

psql "$SUPABASE_DB_URL" -c "SELECT count(*) FROM public.payments;"

 count 
-------
    80
(1 row)

pg_dump "$SUPABASE_DB_URL" --table=public.payments --data-only --column-inserts --no-owner --no-privileges -f /tmp/payments_backup.sql
echo "Exit: $?"

Exit: 0

wc -l /tmp/payments_backup.sql && head -5 /tmp/payments_backup.sql && echo "..." && tail -5 /tmp/payments_backup.sql

113 /tmp/payments_backup.sql
--
-- PostgreSQL database dump
--

\restrict kWdddTl1VjFwhL2Fnt5BIDZKGdhG9eID7gojhgiSJAYnSuiWnvUpKprzOM2h2RI
...
-- PostgreSQL database dump complete
--

\unrestrict kWdddTl1VjFwhL2Fnt5BIDZKGdhG9eID7gojhgiSJAYnSuiWnvUpKprzOM2h2RI

grep -c '^INSERT INTO' /tmp/payments_backup.sql

80

psql "$SUPABASE_DB_URL" -c "SELECT public.run_incident();"

   run_incident    
-------------------
 incident executed
(1 row)

psql "$SUPABASE_DB_URL" -c "SELECT count(*) FROM public.payments;" -c "SELECT * FROM public.incident_log ORDER BY created_at DESC LIMIT 3;"

 count 
-------
    54
(1 row)

ERROR:  column "created_at" does not exist
LINE 1: SELECT * FROM public.incident_log ORDER BY created_at DESC L...
                                                   ^

psql "$SUPABASE_DB_URL" -c "SELECT * FROM public.incident_log;" -c "\d public.incident_log"

 id |            ran_at             |               details                
----+-------------------------------+--------------------------------------
  1 | 2026-07-24 05:55:23.846875+00 | payments corrupted by incident drill
(1 row)

                                 Table "public.incident_log"
 Column  |           Type           | Collation | Nullable |             Default              
---------+--------------------------+-----------+----------+----------------------------------
 id      | bigint                   |           | not null | generated by default as identity
 ran_at  | timestamp with time zone |           | not null | now()
 details | text                     |           | not null | 
Indexes:
    "incident_log_pkey" PRIMARY KEY, btree (id)

psql "$SUPABASE_DB_URL" -c "\d public.payments"

                         Table "public.payments"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 id           | integer                  |           | not null | 
 ref_code     | text                     |           | not null | 
 payer        | text                     |           | not null | 
 amount_cents | integer                  |           | not null | 
 paid_at      | timestamp with time zone |           | not null | 
Indexes:
    "payments_pkey" PRIMARY KEY, btree (id)

grep '^INSERT INTO' /tmp/payments_backup.sql > /tmp/payments_inserts.sql
head -2 /tmp/payments_inserts.sql && echo "..." && tail -2 /tmp/payments_inserts.sql && wc -l /tmp/payments_inserts.sql

INSERT INTO public.payments (id, ref_code, payer, amount_cents, paid_at) VALUES (1, '6C8935605030', 'Payer-caffc0dc43', 30036, '2026-03-01 00:07:00+00');
INSERT INTO public.payments (id, ref_code, payer, amount_cents, paid_at) VALUES (2, '300351D74397', 'Payer-b964e8caa9', 101426, '2026-03-01 00:14:00+00');
...
INSERT INTO public.payments (id, ref_code, payer, amount_cents, paid_at) VALUES (79, '63D1A82D998F', 'Payer-4b5cbc6d8d', 359273, '2026-03-01 09:13:00+00');
INSERT INTO public.payments (id, ref_code, payer, amount_cents, paid_at) VALUES (80, 'E02258DCCE80', 'Payer-180be3be40', 267068, '2026-03-01 09:20:00+00');
80 /tmp/payments_inserts.sql

psql "$SUPABASE_DB_URL" -c "
SELECT conname, conrelid::regclass AS fk_table, a.attname AS fk_column, confrelid::regclass AS referenced_table
FROM pg_constraint c
JOIN pg_attribute a ON a.attnum = ANY(c.conkey) AND a.attrelid = c.conrelid
WHERE confrelid = 'public.payments'::regclass AND contype = 'f';
"

 conname | fk_table | fk_column | referenced_table 
---------+----------+-----------+------------------
(0 rows)

psql "$SUPABASE_DB_URL" <<'EOF'
BEGIN;
DELETE FROM public.payments;
\i /tmp/payments_inserts.sql
COMMIT;
EOF
echo "Exit: $?"

BEGIN
DELETE 54
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
COMMIT
Exit: 0

psql "$SUPABASE_DB_URL" -c "
SELECT 'payments count' AS check, count(*)::text FROM public.payments
UNION ALL
SELECT 'incident_log count', count(*)::text FROM public.incident_log
UNION ALL
SELECT 'payments sample (id=1)', payer || ' / ' || ref_code || ' / ' || amount_cents::text FROM public.payments WHERE id = 1
UNION ALL
SELECT 'incident log', ran_at::text || ' — ' || details FROM public.incident_log;
"

         check          |                                count                                 
------------------------+----------------------------------------------------------------------
 payments count         | 80
 incident_log count     | 1
 payments sample (id=1) | Payer-caffc0dc43 / 6C8935605030 / 30036
 incident log           | 2026-07-24 05:55:23.846875+00 — payments corrupted by incident drill
(4 rows)