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@gmail.com]
Sent: Friday, August 02, 2013 4:57 PM
To: Arnold, Sandra L.
Cc: pgsql-admin@postgresql.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@ornl.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?