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. The command that I am running is as follows using a password file to get the password:
/app/PostgreSQL/9.1/bin/pg_dumpall -h hostname -p portnumber -f filename -U backup I am currently running PostgreSQL 9.1.9 on Centos 5.9 where the server is a VM instance. Below is the output from my log. I have changed the actual hostname to hostname for security reasons. 2013-07-12 20:03:07.406 EDT,,,12145,"",51e0993b.2f71,1,"",2013-07-12 20:03:07 EDT,,0,LOG,00000,"connection received: host=hostname port=59753",,,,,,,,,"" 2013-07-12 20:03:07.410 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,2,"authentication",2013-07-12 20:03:07 EDT,2/88775,0,LOG,00000,"connection authorized: user=backup database=postgres",,,,,,,, ,"" 2013-07-12 20:03:07.414 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,3,"idle",2013-07-12 20:03:07 EDT,2/88776,0,LOG,00000,"statement: SET search_path = pg_catalog",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.414 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,4,"SET",2013-07-12 20:03:07 EDT,2/0,0,LOG,00000,"duration: 0.732 ms",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.424 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,5,"idle",2013-07-12 20:03:07 EDT,2/88777,0,LOG,00000,"statement: SELECT oid, rolname, rolsuper, rolinherit, rolcreaterole, ro lcreatedb, rolcanlogin, rolconnlimit, rolpassword, rolvaliduntil, rolreplication, pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment FROM pg_authid ORDER BY 2",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.430 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,6,"SELECT",2013-07-12 20:03:07 EDT,2/0,0,LOG,00000,"duration: 6.402 ms",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.430 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,7,"idle",2013-07-12 20:03:07 EDT,2/88778,0,LOG,00000,"statement: SELECT setconfig[1] FROM pg_db_role_setting WHERE setdatabas e = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'arnoldsl')",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.431 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,8,"SELECT",2013-07-12 20:03:07 EDT,2/0,0,LOG,00000,"duration: 0.803 ms",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.432 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,9,"idle",2013-07-12 20:03:07 EDT,2/88779,0,LOG,00000,"statement: SELECT setconfig[2] FROM pg_db_role_setting WHERE setdatabas e = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'arnoldsl')",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.432 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,10,"SELECT",2013-07-12 20:03:07 EDT,2/0,0,LOG,00000,"duration: 0.601 ms",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.433 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,11,"idle",2013-07-12 20:03:07 EDT,2/88780,0,LOG,00000,"statement: SELECT setconfig[1] FROM pg_db_role_setting WHERE setdataba se = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'backup')",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.433 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,12,"SELECT",2013-07-12 20:03:07 EDT,2/0,0,LOG,00000,"duration: 0.555 ms",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.435 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,13,"idle",2013-07-12 20:03:07 EDT,2/0,0,LOG,08P01,"unexpected EOF on client connection",,,,,,,,,"pg_dumpall" 2013-07-12 20:03:07.435 EDT,"backup","postgres",12145,"hostname:59753",51e0993b.2f71,14,"idle",2013-07-12 20:03:07 EDT,,0,LOG,00000,"disconnection: session time: 0:00:00.029 user=backup database=postgres host=hostname port=59753",,,,,,,,,"pg_dumpall" Please let me know if I need to provide any other information. Thanks, Sandra Arnold Database/Data Warehouse Administrator MartinFederal Consulting Consultant to Oak Ridge National Laboratory Computational Data Analytics Group Data Architectures Team Building 5100, M/S 6173 OAK RIDGE TN 37831-6173 (865)241-1530
