Re: Some advanced database features, are they present in PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some advanced database features, are they present in PostgreSQL
Date: 2000-10-10 17:42:05
Message-ID: 19789.971199725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Don Baccus 2000-10-10 17:42:42 Re: [HACKERS] My new job
Previous Message Adam Lang 2000-10-10 17:37:33 Re: Re: [HACKERS] My new job