Re: pg_upgrade bug found!

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade bug found!
Date: 2011-04-09 01:57:08
Message-ID: 20110409015708.GI4548@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

bricklen,

* bricklen (bricklen(at)gmail(dot)com) wrote:
> I've been noticing in my logs for the past few days the message you
> note in the wiki. It seems to occur during a vacuum around 7:30am
> every day. I will be running the suggested script shortly, but can
> anyone tell me in how bad of shape my db is in? This is our production
> db with two hot standby's running off it.

Unfortunately, I don't think the script that Bruce posted will help if
the clog files have been removed (which appears to be the case here).
Do you have a backup which includes older files which existed under the
'pg_clog' directory under your database's root? Hopefully you do and
can restore those and restart the database. If you restore and then
restart then Bruce's script could be run and hopefully would clear out
these errors.

Bruce, please correct me if I got any part of this wrong.

Thanks,

Stephen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message bricklen 2011-04-09 02:01:27 Re: pg_upgrade bug found!
Previous Message Stephen Frost 2011-04-09 01:54:06 Re: using a lot of maintenance_work_mem