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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Steve King <steve(dot)king(at)ecmsys(dot)co(dot)uk>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is postgres 7.2.1 safe if there is a power fail.
Date: 2003-05-22 17:03:09
Message-ID: Pine.LNX.4.33.0305221102250.23585-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-05-22 17:44:15 Re: Is postgres 7.2.1 safe if there is a power fail.
Previous Message Tom Lane 2003-05-22 16:05:29 Re: [COMMITTERS] pgsql-server/src backend/commands/variable.c b ...