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

Re: Incomplete pg_dump operation

From: peter(at)vfemail(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Incomplete pg_dump operation
Date: 2010-02-07 13:50:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Done.  The command generates no response.  I'm returned to a command prompt.  If I append a semicolon to the command, I get a syntax error. 


At 07:39 AM 2/7/2010, Francisco Leovey wrote:
>Just do a
> SELECT * from xyz where OID = 2196359751
>--- On Sun, 2/7/10, peter(at)vfemail(dot)net <peter(at)vfemail(dot)net> wrote:  
>From: peter(at)vfemail(dot)net <peter(at)vfemail(dot)net> 
>Subject: Re: [NOVICE] Incomplete pg_dump operation 
>To: pgsql-novice(at)postgresql(dot)org 
>Date: Sunday, February 7, 2010, 9:36 AM
>Thinking more about corruption of some type inside my database and whether an index has become corrupted, I investigated the REINDEX command described at pp. 288 and 847-849 of the 1335-page PostgreSQL 7.4.2 Documentation manual at <<>> 
>This morning, I executed a:
>    REINDEX DATABASE database_name FORCE; 
>command, and received a bunch of:
>    NOTICE:  table "pg_xxxxx" was reindexed 
>messages -- which all look just fine.  
>I then executed a:
>    REINDEX TABLE xyz; 
>command -- using the table name pg_dump was complaining about yesterday -- and received this message:
>    ERROR:  could not open relation with OID 2196359751
>making reference to the same OID pg_dump complained about yesterday.  
>How do I identify this offensive data record that's causing so much disruption and, perhaps, delete it?  
>At 10:08 AM 2/6/2010, <>peter(at)vfemail(dot)net wrote:
>>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 ({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?  
>Sent via pgsql-novice mailing list (<>pgsql-novice(at)postgresql(dot)org) 
>To make changes to your subscription: 

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2010-02-07 16:29:51
Subject: Re: Incomplete pg_dump operation
Previous:From: peterDate: 2010-02-07 11:36:02
Subject: Re: Incomplete pg_dump operation

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