Re: unexpected EOF on client connection during pg_dumpall

It does not write anything to stdout and stderr.  The only thing I see is the error in the server's csv file.  However,
Igot this to work by adding the following to the command line "su - postgres -c " and having the pg_dumpall command in
doublequotes.  I was trying to run this as root but for some reason it did not like it.
 

Sandra Arnold
Database/Data Warehouse Administrator
MartinFederal Consulting
Consultant to Oak Ridge National Laboratory
Computational Data Analytics Group
Data Architectures Team

-----Original Message-----
From: Kevin Grittner [mailto:kgrittn@ymail.com] 
Sent: Thursday, August 01, 2013 2:24 PM
To: Arnold, Sandra L.; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unexpected EOF on client connection during pg_dumpall

"Arnold, Sandra L." <arnoldsl@ornl.gov> wrote:

> I am currently getting a “unexpected EOF on client connection”
> when running pg_dumpall from a bash shell script in cron.  I have 
> looked online to see if anyone else is having or have had this problem 
> without any luck.  I am hoping someone can point me in the right 
> direction to determine what is happening.  When I run the command 
> manually it works.

> Please let me know if I need to provide any other information.

What does pg_dumpall write to stdout and stderr?  I have only seen the server-side error you show when the pg_dumpall
clienthad an error writing, due to permissions problems or disk space exhaustion, and the reason needs to be found on
the"client" side, not in the server log.
 

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company