Re: Loss of data and info from system tables!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: noel(dot)faux(at)med(dot)monash(dot)edu(dot)au
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Postgres <pgsql-novice(at)postgresql(dot)org>, hu ping <hping(at)vpac(dot)org>
Subject: Re: Loss of data and info from system tables!!
Date: 2005-03-31 05:09:12
Message-ID: 2197.1112245752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> writes:
> We generally only vacuum
> tables which are affected by deletes, inserts and updates.

You can't do that as an exclusive practice :-(. In particular I suppose
that you never vacuumed your system catalogs at all, and now you are
behind the eight ball because transaction IDs wrapped around. See
http://www.postgresql.org/docs/7.4/static/maintenance.html#VACUUM-FOR-WRAPAROUND

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Noel Faux 2005-03-31 05:51:33 Re: Loss of data and info from system tables!!
Previous Message Michael Fuhr 2005-03-31 05:07:49 Re: Loss of data and info from system tables!!