Re: Lost databases

From: Liviu BURCUSEL <liviu(at)voxline(dot)ro>
To: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Lost databases
Date: 2004-11-11 07:43:56
Message-ID: 20041111094356.0ef75151@winston.voxline.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message kevin.barnard 2004-11-11 07:48:15 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Previous Message Björn Platzen 2004-11-11 07:13:16 Can't insert date in field with foreign key