Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table
Date
Msg-id 29360.1459799797@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table  (dll@sonic.net)
Responses Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table
List pgsql-bugs
Tree view 
dll@sonic.net writes:
> 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

Sounds like an SSL renegotiation bug.  We gave up on that mess and
disabled renegotiation by default as of 9.4.5 or so, but maybe you have
an explicit nonzero setting for ssl_renegotiation_limit?

            regards, tom lane

pgsql-bugs by date:

Previous
From: julian.schauder@credativ.de
Date:
Subject: BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable.
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`