Re: Where art thou pg_clog? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Where art thou pg_clog?
Date
Msg-id a014b443ce49151a00d17c6de01d2ce4@biglumber.com
Whole thread Raw
In response to Re: Where art thou pg_clog?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> The real bottom line here, and one I'll reiterate every chance I get,
> is that we don't make updates to back branches because we're too bored
> to have anything else to do.  If you're on 8.1.5, and the current
> release in that branch is 8.1.8, then you're missing some bug fixes
> that are probably significant.

Just as a data point, I came across this very same problem (corrupted
tuple header, invalid xlog file) on an 8.1.3 system that was NOT
running autovacuum (and never had). Amazingly, this occured on the
very same day as the original poster. The server was upgraded to 8.2.3,
after some creating-bogus-xlog-file pain to extract all the data, and
all is well again.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200702221021
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFF3bW8vJuQZxSWSsgRA45cAKCQYcPdmqvNh9KRBGNsm/YjycmqFQCgzIil
nUXZs7wIJvkxs6RaBTW5cKA=
=V0YI
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: "Chris Coleman"
Date:
Subject: Slony subscription problem
Next
From: Tom Lane
Date:
Subject: Re: Infinite loop in transformExpr()