Skip site navigation (1) Skip section navigation (2)

Incomplete pg_dump operation

From: peter(at)vfemail(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Incomplete pg_dump operation
Date: 2010-02-06 15:08:50
Message-ID: 20100206150936.9FC3B632298@mail.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
A shell script runs pg_dump once each day to backup a Postgresql database and then compress it for storage.  The script and backup process worked flawlessly for years, but now returns these error messages:

   pg_dump: ERROR:  could not open relation with OID 2196359751
   pg_dump: SQL command to dump the contents of table "xyz" failed: PQendcopy() failed.
   pg_dump: Error message from server: ERROR:  could not open relation with OID 2196359751
   pg_dump: The command was: COPY public.xyz ({various_field_names}) TO stdout;

The pg_dump command halts with these error messages after copying or dumping about 50% of the database.  Accordingly, only a fraction of the database is actually being backed up.  

Is there corruption of some type inside my PostgreSQL database?  Has an index or something similar become corrupted?  



pgsql-novice by date

Next:From: peterDate: 2010-02-07 11:36:02
Subject: Re: Incomplete pg_dump operation
Previous:From: peterDate: 2010-02-06 14:11:36
Subject: Re: Database handle destroyed without explicit disconnect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group