Re: Lost databases - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: Lost databases
Date
Msg-id 20041110161101.36670.qmail@web20828.mail.yahoo.com
Whole thread Raw
In response to Lost databases  (Liviu BURCUSEL <liviu@voxline.ro>)
Responses Re: Lost databases
List pgsql-general
--- Liviu BURCUSEL <liviu@voxline.ro> wrote:

> Hi !
>
> I'm in the ultimate state of dispair. Over the night
> some of my
> databases just disapeared. But they did not dissaper
> totally. I can
> still connect to them but I cannot dump them. When
> doing a "select *
> from pg_database" I see only 2 databases I hardly
> ever use (they are
> used once in a couple of mounths). Template0 and
> template1 are missing.
> All the databases that I currently use dissapeared!
>
> Please help me to restore the integrity of the
> system. I'm in dense fog
> here :(

What Postgresql version is this?  Your problem sounds
like "oid wraparound".  There was a recent discussion
of this on the list; try the list archives to see what
was recommended in that case.

>
> Liviu
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>




__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com



pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Important Info on comp.databases.postgresql.general
Next
From: Peter Eisentraut
Date:
Subject: Re: Important Info on comp.databases.postgresql.general