Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group