Re: ERROR: XLogFlush: request

> An upgrade from 7.3.x to 7.3.18 is pretty close to painless

http://www.postgresql.org/docs/7.3/static/release-7-3-13.html
http://www.postgresql.org/docs/7.3/static/release-7-3-10.html

Can't do it blindfolded but still it can be categorized as painless :)

> 2: Do not upgrade to 8.1.0. It's been updated many times since then. I
think the latest 8.1.x is 8.1.8 or so. Get that.

Thanx and understood

> 3: Keep your versions updated and you should avoid most situations like
this in the future.

I hope I do realize that by now :)

I can see something change on
http://www.postgresql.org/docs/7.3/static/release-7-3-5.html

* Force zero_damaged_pages to be on during recovery from WAL

Is this related to XLogFlush problem?

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe(at)g2switchworks(dot)com]
Sent: Friday, April 13, 2007 9:26 PM
To: Nitin Verma
Cc: pgsql general
Subject: Re: [GENERAL] ERROR: XLogFlush: request

On Fri, 2007-04-13 at 10:10, Nitin Verma wrote:
> Thanx Tom, anyway we are moving to 8.1.0 soon.
>
> Leaving that moving all our client to newer release will take sometime. I
> hope you know how it works in a product. Till that time we need to release
a
> patch that recovers from this condition.
>
> Said that, do we have some advice or workarounds?
>
> I saw 8.1.0's code; it even ends up handling the same condition.

A couple of points.

1: This problem may be fixed in the latest 7.3.18 version. An upgrade
from 7.3.x to 7.3.18 is pretty close to painless. Shut down pgsql,
update package, startup pgsql. Backup beforehand is a nice option, but
you should have backups already anyway...

2: Do not upgrade to 8.1.0. It's been updated many times since then.
I think the latest 8.1.x is 8.1.8 or so. Get that.

3: Keep your versions updated and you should avoid most situations like
this in the future.