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
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.
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