Hello Tom,
thanks for your answer.
But I don't understand why there are changes of the databases template1 and
template0 at all?
I thought they are only templates.
Regards
Michaela
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "MG" <[EMAIL PROTECTED]>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, February 15, 2007 4:57 PM
Subject: Re: [GENERAL] WARNING: some databases have not been vacuumed in
1953945422 transactions
"MG" <[EMAIL PROTECTED]> writes:
Each night a shell script is being executed.
vacuumdb --analyze -U cmduser db1
vacuumdb --analyze -U cmduser db2
You need to hit template1 every so often, too. You probably might
as well just do that every night; it won't take long.
The last weeks the following warnings are given out:
WARNING: some databases have not been vacuumed in 1953945422 =
transactions
Is this critical?
Yes.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
