Re: unexpected EOF on client connection during pg_dumpall

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(at)gmail(dot)com]
Sent: Friday, August 02, 2013 4:57 PM
To: Arnold, Sandra L.
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] unexpected EOF on client connection during pg_dumpall

On Fri, Aug 2, 2013 at 11:33 AM, Arnold, Sandra L. <arnoldsl(at)ornl(dot)gov<mailto:arnoldsl(at)ornl(dot)gov>> 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?