Postgres Pro
Downloads
Home   >   mailing lists

Re: [ISSUE] pg_dump: schema with OID 0 does not exist - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [ISSUE] pg_dump: schema with OID 0 does not exist
Date
Msg-id CA+TgmoZL5L_ps7_wyHeuJWmYpiHe0ZtWKj3OSQ_Y_hsRXqgDQQ@mail.gmail.com
Whole thread Raw
In response to Re: [ISSUE] pg_dump: schema with OID 0 does not exist  (Prakash Itnal <prakash074@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Mar 11, 2014 at 12:23 AM, Prakash Itnal <prakash074@gmail.com> wrote:
> Can someone confirm is this really an issue? or any reasons for missing
> rows?

Well, your database is definitely getting corrupted somehow.  But
there's no information in your email which would enable someone to
guess how.

I blogged on this subject a while back, but I don't know whether it's
relevant to your situation:

http://rhaas.blogspot.com/2012/03/why-is-my-database-corrupted.html

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Parul Lakkad
Date:
Subject: Disk usage for intermediate results in join
Next
From: Heikki Linnakangas
Date:
Subject: Re: Disk usage for intermediate results in join