unexpected EOF on client connection during pg_dumpall

Поиск
Список
Период
Сортировка
От Arnold, Sandra L.
Тема unexpected EOF on client connection during pg_dumpall
Дата
Msg-id F7D6A12B572935439E34065CFADC851CE6A137519E@EXCHMBB.ornl.gov
обсуждение исходный текст
Ответы Re: unexpected EOF on client connection during pg_dumpall  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: unexpected EOF on client connection during pg_dumpall  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-admin

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

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Lucas Restrepo gil
Дата:
Сообщение: Fw:
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unexpected EOF on client connection during pg_dumpall