Steve Wampler <[EMAIL PROTECTED]> writes:
> I'm getting the following error from pg_dump when trying to
> dump a particular database:
> ==============================================================
> -> pg_dump logdb >logdb.dump
> pqWait() -- connection not open
> PQendcopy: resetting connection
> SQL query to dump the contents of Table 'messages' did not execute correctly. After
>we read all the table contents from the backend, PQendcopy() failed. Explanation
>from backend: 'The Data Base System is starting up
> '.
> The query was: 'COPY "messages" TO stdout;
> '.
> ==============================================================
> About 25MB has been dumped when this error occurs. (There's 15GB
> free on the disk partition.)
Looks like you've got corrupted data in that table (clobbered length
word in some variable-length field, most likely).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
