% pg_dump -h d01-prv -Fc -f mm.22-Mar-2005.dump vkmlm
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "user_list" failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.user_list ( ... list elided for privacy concerns ... )
the postgres log on the server has this to say:
Mar 22 10:35:00 d01 postgres[35190]: [8-1] LOG: could not receive data from client: Operation timed out
Mar 22 10:35:00 d01 postgres[35190]: [9-1] LOG: unexpected EOF on client connection
the overnight dump had this error:
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "user_list" failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.user_list ( ... )
Mar 22 03:42:10 d01 postgres[33589]: [6-1] LOG: could not send data to client: Broken pipe
Mar 22 03:47:10 d01 postgres[33589]: [7-1] LOG: duration: 473083.960 ms statement:
[ the COPY query ]
Mar 22 03:47:10 d01 postgres[33589]: [8-1] LOG: could not receive data from client: Operation timed out
Mar 22 03:47:10 d01 postgres[33589]: [9-1] LOG: unexpected EOF on client connection
While poking through the logs for these errors, I'm finding a *lot* of broken pipe/unexpected EOF errors for this server but for connections from other hosts as well, running reports. those hosts still have the 7.4 client libraries.
This is a brand new box (rushed into production after minimal testing since one other died, so I'm not 100% certain it is stable) running FreeBSD 5.4-PRERELEASE amd64 on a dual Opteron with 4GB ram and MegaRAID RAID.
The same config on the old box with Pg 7.4.7 worked flawlessly for running reports and dumps. Another issue is that the 8.0 server is noticeably slower than the 7.4 with identically (translated to 8.0 style) configs.
Any ideas on where to poke around for the pipe problems?
Vivek Khera, Ph.D. +1-301-869-4449 x806
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
