pg_dump: error: Error message from server: SSL SYSCALL error: EOF detected

How to solve Postgres dump error: Dumping the contents of table failed: PQgetCopyData() failed

You may see the following errors:

 
  • pg_dump: detail: Error message from server: SSL SYSCALL error: EOF detected
  • pg_dump: error: Dumping the contents of table "my_table" failed: PQgetCopyData() failed
  • pg_dump: detail: Error message from server: could not receive data from server: Connection timed out
  • pg_dump: detail: Command was: COPY public.my_table (a, b, c, d, …) TO stdout;
 

This error could happen if your database has very little resources available, or very little RAM.

 

If you cannot upgrade your database to a more powerful one, refer to https://www.roelpeters.be/error-ssl-syscall-error-eof-detected/ for more information.

Did this answer your question?
😞
😐
🤩

Last updated on January 30, 2023