Re: Undead record haunts my database, need exorcism

From: Kevin Sterner <sterner(at)hep(dot)upenn(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Undead record haunts my database, need exorcism
Date: 2002-05-22 15:14:08
Message-ID: 200205221514.LAA09567@higgs.hep.upenn.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


> 6.5.3? You are past due for an update ...

Concur. I have some inertia to overcome on that, however. Meanwhile,
I need to get the old jalopy back on the road.

> Hmm. How large is your pg_log file? I suspect that you have suffered
> transaction ID wraparound. If the pg_log file is 1Gb in size (enough
> to store commit bits for 4 billion transactions) that would confirm the
> suspicion.

The pg_log file is only 4 Mbytes. The database is not very active; fewer
than 100 records per day get stored. Is such a wraparound still possible?
If so, how would I detect it and/or fix it?

> Whether that's the problem or not, 6.5.3 is enough features and bugfixes
> ago that I would wholeheartedly recommend an immediate update to 7.2.1.

Does that version still support AIX?

Thanks,

Kevin

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-05-22 15:19:48 Re: Undead record haunts my database, need exorcism
Previous Message Rasmus Mohr 2002-05-22 14:29:50 Re: optimising data load