Re: Loss of data and info from system tables!! - Mailing list pgsql-novice

From Tom Lane
Subject Re: Loss of data and info from system tables!!
Date
Msg-id 2197.1112245752@sss.pgh.pa.us
Whole thread Raw
In response to Re: Loss of data and info from system tables!!  (Noel Faux <noel.faux@med.monash.edu.au>)
Responses Re: Loss of data and info from system tables!!
List pgsql-novice
Noel Faux <noel.faux@med.monash.edu.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

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Loss of data and info from system tables!!
Next
From: Noel Faux
Date:
Subject: Re: Loss of data and info from system tables!!