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 <[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 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 [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
