| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Joseph Shraibman <jks(at)selectacast(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What happens when wal fails? |
| Date: | 2005-09-11 20:25:15 |
| Message-ID: | 432492AB.7050205@samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Joseph Shraibman <jks(at)selectacast(dot)net> writes:
>>If I put the pg_xlog directory on its own disk, then that disk fails,
>>does that mean the postgres is hosed or does it just mean that postgres
>>no longer safe from a power outage?
>
> The latter. The WAL is actually write-only during normal operation.
Well, data loss is certainly possible. Suppose a power failure caused
the machine to go down and (for whatever reason) also resulted in losing
the disk on which the WAL is stored. Since recovery will not be
possible, there will probably be data corruption.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-09-11 21:41:09 | Re: back references using regex |
| Previous Message | mike dixon | 2005-09-11 17:36:26 | linux pg pointed to windows partition for db |