Re: [ISSUE] pg_dump: schema with OID 0 does not exist

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Prakash Itnal <prakash074(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [ISSUE] pg_dump: schema with OID 0 does not exist
Date: 2014-03-11 12:13:02
Message-ID: CA+TgmoZL5L_ps7_wyHeuJWmYpiHe0ZtWKj3OSQ_Y_hsRXqgDQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 11, 2014 at 12:23 AM, Prakash Itnal <prakash074(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-03-11 12:22:45 Re: Disk usage for intermediate results in join
Previous Message Parul Lakkad 2014-03-11 11:24:57 Disk usage for intermediate results in join