Re: Database disappeared

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database disappeared
Date: 2005-07-27 14:23:05
Message-ID: 25685.1122474185@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-07-27 14:27:14 Re: Problem with the compilation and running of postgresql
Previous Message Tom Lane 2005-07-27 14:13:12 Re: error on launching postgres in ssl mode