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.