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 vacuum.
Thanks for the VACUUM idea. I thought it was happening every Sunday.
Thanks for the help.
Regards
Marco
On Wed, 2005-07-27 at 10:23 -0400, Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> !DSPAM:42e79f14190891268238603!
>
>
> Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
> If you don't have web access, the disclaimer can be mailed to you on request.
> Disclaimer requests to be sent to it-security@pnp.co.za
>
Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security@pnp.co.za