Pg_dump hangs

Help
1

I am trying to use PG dump to dump my production database on PostgreSQL 16.6 for testing. Currently the database is only 70MB, so I expect this should be a relatively easy process.

So far, when I use the tool via command line, it simply hangs. The command I am using is as follows:

pg_dump -Fc -v -d “postgres connection link” -f snapIF_Prod_Backup_2_11_25_4-28-pm.dump

I am using the connection link from Neon with connection pooling turned off. Another thing I have noticed is that when calling this, the compute on neon does not spin up.

Any idea what I need to do to get this working?

2

I got it working after reinstalling posgress command line tools.

1 Like
3

Hello,

If you are using Neon Postgres SQL, we recommend reaching out to Neon Support team to investigate the issue: Support - Neon Docs

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.