Re: Some advanced database features, are they present in PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: Some advanced database features, are they present in PostgreSQL
Date
Msg-id 19789.971199725@sss.pgh.pa.us
Whole thread Raw
In response to Re: Some advanced database features, are they present in PostgreSQL  (Peter Eisentraut <peter_e@gmx.net>)
Responses TEXT vs VARCHAR  ("chris markiewicz" <cmarkiew@commnav.com>)
List pgsql-general
>> - hard transactions: cutting the power to a PostgreSQL server
>> may cause data loss and/or data corruption.

That is false; Postgres is secure now against power failures,
at least if you run in the default mode with lots of fsync()s.

The WAL feature planned for 7.1 should make performance better,
but it won't make any fundamental change in reliability for power
failures.

The existing server does not offer any protection against disk hardware
failure, however.  RAID disks might be an adequate answer to that.

            regards, tom lane

pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: Re: [HACKERS] My new job
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] My new job