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
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
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
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
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