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:brick...@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. <arnol...@ornl.gov<mailto:arnol...@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?
