pg_dump fails when it gets to table containing bytea

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;

Responses

Browse pgsql-general by date

  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