Re: Lost databases

--- Liviu BURCUSEL <liviu(at)voxline(dot)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