BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table - Mailing list pgsql-bugs

From dll@sonic.net
Subject BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table
Date
Msg-id 20160404173217.15198.47508@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14062
Logged by:          Dan Liddell
Email address:      dll@sonic.net
PostgreSQL version: 9.4.6
Operating system:   Red Hat Enterprise Linux Server release 7.2 (Maipo
Description:


For an approximately 500 gigabyte database, pg_dump dies after approximately
60 gb of text output, with an error:

pg_dump: Dumping the contents of table "datum" failed: PQgetCopyData()
failed.
pg_dump: Error message from server: SSL SYSCALL error: EOF detected
pg_dump: The command was: COPY hrrr.datum (dr_id, qtime, grid_id, gust,
ugrd80, vgrd80, pres, tmp, dpt, ugrd10, vgrd10, dswrf) TO stdout;

The command used is:
 pg_dump -n hrrr --username=webuser --host=<some AWS RDS host> hrrr_db

The host is remote, and the connection is encrypted.

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Breakage with VACUUM ANALYSE + partitions
Next
From: julian.schauder@credativ.de
Date:
Subject: BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable.