Re: Lost databases

On Wed, 10 Nov 2004 08:11:01 -0800 (PST)
Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> wrote:

> --- 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.
>
The Postgresql version is 7.4.1

Thanks. I'll look in the archive.

Liviu