Re: transaction-wraparound data loss

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brian E(dot) Pangburn" <bpangburn(at)nqadmin(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: transaction-wraparound data loss
Date: 2003-09-10 06:30:33
Message-ID: 545.1063175433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Brian E. Pangburn" <bpangburn(at)nqadmin(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alexander V. Ivanko 2003-09-10 09:18:35 unsubscribe
Previous Message Gaetano Mendola 2003-09-10 02:20:42 Re: How to create schema-specific users?