Re: New system recommendations

From: Robin Iddon <robin(at)edesix(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: New system recommendations
Date: 2006-04-27 16:24:56
Message-ID: 4450F058.4070600@edesix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


>Assuming that presently the server's capability as far as drives is 3
>drives, would you recommend doing a RAID-1 on 2 drives and an additional
>non RAIDed drive to hold the WAL? Anything else which shold be moved to
>the other spindle?
>
>
>
I would RAID-1 the WAL. Assuming you have a mechanism to keep the logs
since the last backup you should be able to restore from that last
backup and logs without the data drive. The reverse isn't true - if you
lose the WAL but have the data drive, it may not be consistent ...

Robin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-04-27 17:49:54 Re: New system recommendations
Previous Message Craig Servin 2006-04-27 15:40:29 Alter table alter column using question