Re: Lost databases - Mailing list pgsql-general

From Liviu BURCUSEL
Subject Re: Lost databases
Date
Msg-id 20041111094356.0ef75151@winston.voxline.ro
Whole thread Raw
In response to Re: Lost databases  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-general
On Wed, 10 Nov 2004 08:11:01 -0800 (PST)
Jeff Eckermann <jeff_eckermann@yahoo.com> wrote:

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

Thanks. I'll look in the archive.

Liviu

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: pg_ctl and stderr
Next
From: kevin.barnard@gmail.com
Date:
Subject: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX