From: | "Carlos Oliva" <carlos(at)pbsinet(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump fails when it gets to table containing bytea |
Date: | 2005-10-27 14:30:07 |
Message-ID: | 200510271431.KAA29874@pbsi.pbsinet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Could anyone suggest something that we can check to ascertain why pg_dumps
fail? The pg_dump for our database just started to fail this week. Dumps
of the same database succeeded just last week. Moreover, we can create a
new database using the database (that we are trying to dump) as a template
and the data is copied into the new database.
We are getting the following error message whe we run "pg_dump -Ft <database
name> > database.tar":
pg_dump: ERROR: canceling query due to user request
pg_dump: SQL command to dump the contents of table "blob" failed:
PQendcopy() fa
iled.
pg_dump: Error message from server: ERROR: canceling query due to user
request
pg_dump: The command was: COPY public.blob (prtnbr, bkey, bdsc, btypnbr,
bcrtdte
, bcrttme, bcrtusr, bflepath, bflenam, bfleext, bsetnbr, cblob) TO stdout;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-10-27 15:07:37 | Re: Why database is corrupted after re-booting |
Previous Message | Alex Stapleton | 2005-10-27 14:16:14 | Re: Why database is corrupted after re-booting |