Thread: Is postgres 7.2.1 safe if there is a power fail.

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

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

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.