BUG #16891: pg_dump: Error message from server: SSL SYSCALL error: EOF detected

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16891: pg_dump: Error message from server: SSL SYSCALL error: EOF detected

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      16891
Logged by:          Chandrasekhar Penchikala
Email address:      [hidden email]
PostgreSQL version: 11.8
Operating system:   Linux
Description:        

Hi,

I am trying to backup postgresql database using pg_dump , we are seeing
below error. I am trying to take the pg backup of AuroraPostgresql RDS from
my local machine.

pg_dump: Dumping the contents of table  failed: PQgetCopyData() failed.
pg_dump: Error message from server: SSL SYSCALL error: EOF detected


Regards,
Chandra.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16891: pg_dump: Error message from server: SSL SYSCALL error: EOF detected

Álvaro Herrera
On 2021-Feb-23, PG Bug reporting form wrote:

> I am trying to backup postgresql database using pg_dump , we are seeing
> below error. I am trying to take the pg backup of AuroraPostgresql RDS from
> my local machine.
>
> pg_dump: Dumping the contents of table  failed: PQgetCopyData() failed.
> pg_dump: Error message from server: SSL SYSCALL error: EOF detected

I have seen similar problems occur when the network between client and
server are not reliable -- for example you may have a router closing
ports when too much data has been transferred, or things like that.

--
Álvaro Herrera                            39°49'30"S 73°17'W