Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction-wraparound data loss - Mailing list pgsql-admin

From Tom Lane
Subject Re: transaction-wraparound data loss
Date
Msg-id 545.1063175433@sss.pgh.pa.us
Whole thread Raw
In response to transaction-wraparound data loss  ("Brian E. Pangburn" <bpangburn@nqadmin.com>)
List pgsql-admin
Tree view 
"Brian E. Pangburn" <bpangburn@nqadmin.com> writes:
> I run the following nightly using cron against my 7.3.3 databases:
> vacuumdb -a -f -z
> The other night, I got the following (db names have been changed to protect
> the innocent):
> WARNING:  Some databases have not been vacuumed in over 2 billion
> transactions.

Hm, that should not happen if you've been doing routine vacuumdb -a.
Could we see the contents of pg_database?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: How to create schema-specific users?
Next
From: "Alexander V. Ivanko"
Date:
Subject: unsubscribe