Skip site navigation (1) Skip section navigation (2)

Re: Undead record haunts my database, need exorcism

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Sterner <sterner(at)hep(dot)upenn(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Undead record haunts my database, need exorcism
Date: 2002-05-22 15:19:48
Message-ID: 3396.1022080788@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Kevin Sterner <sterner(at)hep(dot)upenn(dot)edu> writes:
>> Hmm.  How large is your pg_log file?  I suspect that you have suffered
>> transaction ID wraparound.

> The pg_log file is only 4 Mbytes.

Scratch that theory, then.  I'm not sure why you'd be seeing this odd
behavior.

>> 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?

Sure.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Patrick HatcherDate: 2002-05-22 15:29:07
Subject: Re: optimising data load
Previous:From: Kevin SternerDate: 2002-05-22 15:14:08
Subject: Re: Undead record haunts my database, need exorcism

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group