Re: unexpected EOF on client connection during pg_dumpall

["Arnold, Sandra L." <arnoldsl@xxxxxxxx>]

The script is running on the same server as the database.  However I am using hostname to connect to the database.  Could I be having problems with tcp_keepalives parameter settings?  These are currently set to use the OS defaults which would be CentOS settings. 

 

Sandra Arnold

Database/Data Warehouse Administrator

MartinFederal Consulting

Consultant to Oak Ridge National Laboratory

Computational Data Analytics Group

Data Architectures Team

 

From: bricklen [mailto:bricklen@xxxxxxxxx]
Sent: Friday, August 02, 2013 4:57 PM
To: Arnold, Sandra L.
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] unexpected EOF on client connection during pg_dumpall

 

On Fri, Aug 2, 2013 at 11:33 AM, Arnold, Sandra L. <arnoldsl@xxxxxxxx> wrote:

2013-08-02 14:04:40.981 EDT,"backup","postgres",21309"hostname:40353",51fbf3a1.533d,48,"idle",2013-08-02 14:00:01 EDT,,0,LOG,00000,"disconnection: session time: 0:04:39.039 user=backup database=postgres host=hostname port=40353",,,,,,,,,"pg_dumpall"

It looks like it completed the COPY statement for the table that it was backing up right before the error message occurred.  I also do not see anything in the backup file that indicates what is happening.

 

Is the entire process occurring on the same host, or is across a network? If the latter, could it be due to timeouts from ssh, or tunnels, or internal load balancers/connection poolers?