Re: Where art thou pg_clog?

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Where art thou pg_clog?
Date: 2007-02-22 15:28:57
Message-ID: a014b443ce49151a00d17c6de01d2ce4@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200702221021
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-22 15:31:16 Re: Infinite loop in transformExpr()
Previous Message Randal L. Schwartz 2007-02-22 15:22:58 Re: postgresql vs mysql