Re: Is postgres 7.2.1 safe if there is a power fail. - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Is postgres 7.2.1 safe if there is a power fail.
Date
Msg-id Pine.LNX.4.33.0305221102250.23585-100000@css120.ihs.com
Whole thread Raw
In response to Is postgres 7.2.1 safe if there is a power fail.  (Steve King <steve.king@ecmsys.co.uk>)
List pgsql-hackers
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.  



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is postgres 7.2.1 safe if there is a power fail.
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql-server/src backend/commands/variable.c b ...