Re: WARNING: some databases have not been vacuumed in 1953945422 transactions - Mailing list pgsql-general

From Tom Lane
Subject Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Date
Msg-id 25763.1171555059@sss.pgh.pa.us
Whole thread Raw
In response to WARNING: some databases have not been vacuumed in 1953945422 transactions  ("MG" <pgsql-general@carladata.de>)
List pgsql-general
"MG" <pgsql-general@carladata.de> 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

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: Recover anything from dropped database?
Next
From: Erik Jones
Date:
Subject: Re: Recover anything from dropped database?