Postgres pg_dump times out

Question

I am running this command on Webfaction:

ionice -c2 -n6 pg_dump --blobs -U mhjohnson_flavma -f dump.sql

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: canceling statement due to statement timeout

Any ideas on how to change the timeout?

score 12 · Accepted Answer · answered Feb 10 '12 at 22:57

12

Your server probably has statement-timeouts configured in one way or another. (cf. here)

As a quick solution, you could use PGOPTIONS="-c statement_timeout=0" pg_dump [...] to temporarily overwrite this setting for the dumping process.

answered Feb 10 '12 at 22:57

fnl

Thanks! Adding `alter user [user_name] set statement_timeout = 0;` worked for me. – user1653042 Jun 29 '23 at 16:19

1 Answers1