Postgres Pro
Downloads
Home   >   mailing lists

Re: Database disappeared - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database disappeared
Date
Msg-id 25685.1122474185@sss.pgh.pa.us
Whole thread Raw
In response to Database disappeared  (Marco Rademeyer <mrademeyer@pnp.co.za>)
Responses Re: Database disappeared  (Marco Rademeyer <mrademeyer@pnp.co.za>)
List pgsql-admin
Tree view 
Marco Rademeyer <mrademeyer@pnp.co.za> writes:
> I have a very strange problem.
> I was importing about 5 gigs of data last night.

> When I got in this morning the script had completed. But my database has
> disappeared. I login to the databases , but all the tables are gone.

Sounds a whole lot like transaction ID wraparound :-(.  How long ago did
you last do a database-wide VACUUM?

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: error on launching postgres in ssl mode
Next
From: Tom Lane
Date:
Subject: Re: Problem with the compilation and running of postgresql