Re: [GENERAL] pg_dump fails when it gets to table containing bytea

2005-10-27 Thread codeWarrior
Is your table really named "blob" ??? You said it fails when it gets to the table named "blob" not somewhere in the process of dumping the table "blob"... There might be a clue in that... What happens if yo rename the table to something other than an SQL reserverd word ? Although postgreSQL doe

Re: [GENERAL] pg_dump fails when it gets to table containing bytea

2005-10-27 Thread Tom Lane
"Carlos Oliva" <[EMAIL PROTECTED]> writes: > We are getting the following error message whe we run "pg_dump -Ft name> > database.tar": > pg_dump: ERROR: canceling query due to user request This implies that something sent SIGINT to the backend process. We've heard some reports that suggest tha

[GENERAL] pg_dump fails when it gets to table containing bytea

2005-10-27 Thread Carlos Oliva
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 t