After creating my Postgres database back in March, I was able to successfully back it up periodically by opening a
flyctl proxy and executing
pg_dump. However, a week ago, the dump started hanging right after “reading user-defined tables”:
❯ pg_dump -U postgres -h localhost -d wordmaster -v pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables
I can connect just fine with
psql -h localhost -d wordmaster and read the entire table:
❯ psql -U postgres -h localhost -d wordmaster psql (14.2, server 14.1 (Debian 14.1-1.pgdg110+1)) Type "help" for help.
wordmaster=# select count(*) from words; count ------- 4891 (1 row)
Any idea why
pg_dump hangs? I tried restarting the postgres instance to no avail.