Re: some databases have not been vacuumed ...

Did you vacuum the template1 database as well as whatever databases you have created ?

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:    pgsql-admin-owner@postgresql.org on behalf of FM
Sent:    Mon 8/1/2005 12:35 PM
To:    Mailing List Postgres-Admin
Cc:
Subject:    [ADMIN] some databases have not been vacuumed  ...
Hello after a vacuum full analyse I received this  :
WARNING:  some databases have not been vacuumed in 1805294030 transactions
HINT:  Better vacuum them within 342189617 transactions, or you may have
a wraparound failure.

I read that it's because i do not vacuum DB very often.
Now I vacuum every night but the warning remains.
How can I get rid of this ?

Thanks !

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

!DSPAM:42ee7af1176271374616439!