|
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; |
