| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | peter | 2010-02-07 11:36:02 | Re: Incomplete pg_dump operation |
| Previous Message | peter | 2010-02-06 14:11:36 | Re: Database handle destroyed without explicit disconnect |