Re: [ADMIN] Database disappeared

2005-07-27 Thread Rainer J. H. Brandt
Hello everybody, sorry if you consider this off-topic, but (despite the serious situation, sorry again) I thought this was funny: Marco wrote > I was getting warparound errors. When I tried to do a vacuum. after Tom had written >> Sounds a whole lot like transaction ID wraparound :-(. How long

Re: [ADMIN] Database disappeared

2005-07-27 Thread Marco Rademeyer
hi All I seems to be that the script that I was running to do the VACUUM FULL on the databases was not doing its job. I have run a VACUUM FREEZ on the databases. This has brought back some of the Databases. I am waiting for it to complete. I was getting warparound errors. When I tried to do a

Re: [ADMIN] Database disappeared

2005-07-27 Thread Tom Lane
Marco Rademeyer <[EMAIL PROTECTED]> 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 l

Re: [ADMIN] Database disappeared

2005-07-27 Thread Guido Barosio
You mention:   script has ended -> so, it was a piece of sql sentences, no drop at any time?   databases disappeared  -> the db is not any more, or the relations are not more there?   Could this script create a schema and moved everything on this schema?   try postgresql-shell # \dn   That should l

[ADMIN] Database disappeared

2005-07-27 Thread Marco Rademeyer
Hi 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. in the /var/lib/postgresql/data/base/17164/ . The data is still th