Is postgres 7.2.1 safe if there is a power fail.
The system is running 24/7/365 and I have had occassional problems with
duplicate records including oids. This happened in two different tables at
the same time, it seems to have appeared immediately after a power (and ups)
fail. Is it a known problem with power fail or is this just a coincidence. I
have tried to scour the maillists and docs but cannot find a definitive
answer to this.

Regards
Steve

Thu, 22 May 2003 10:35:14 +0100
Steve King <steve.king@ecmsys.co.uk>
Is postgres 7.2.1 safe if there is a power fail.
On Thu, 22 May 2003, Steve King wrote:

> Is postgres 7.2.1 safe if there is a power fail.
> The system is running 24/7/365 and I have had occassional problems with
> duplicate records including oids. This happened in two different tables at
> the same time, it seems to have appeared immediately after a power (and ups)
> fail. Is it a known problem with power fail or is this just a coincidence. I
> have tried to scour the maillists and docs but cannot find a definitive
> answer to this.

There are known data loss issues in 7.2.1.  Whether these led to this 
problem I do not know.

You should upgrade immediately to 7.2.4.  


Thu, 22 May 2003 11:03:09 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: Is postgres 7.2.1 safe if there is a power fail.
Steve King <steve.king@ecmsys.co.uk> writes:
> Is postgres 7.2.1 safe if there is a power fail.

You should be running 7.2.4 --- we don't put out patch releases just to
amuse ourselves.

Yes, there are data-loss fixes between 7.2.1 and 7.2.4.

			regards, tom lane

Thu, 22 May 2003 13:44:15 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Is postgres 7.2.1 safe if there is a power fail. 