Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dll(at)sonic(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table
Date: 2016-04-04 19:56:37
Message-ID: 29360.1459799797@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

dll(at)sonic(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message cpacejo 2016-04-04 20:33:04 BUG #14064: Sort order of bytea, etc. not defined
Previous Message julian.schauder 2016-04-04 19:40:24 BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable.