X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ED45A11F6B45 for ; Thu, 27 Apr 2006 13:23:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 65774-05-2 for ; Thu, 27 Apr 2006 13:23:37 -0300 (ADT) X-Greylist: delayed 08:25:30.885924 by SQLgrey- Received: from ranger.systems.pipex.net (ranger.systems.pipex.net [62.241.162.32]) by postgresql.org (Postfix) with ESMTP id 8FD7411F6B19 for ; Thu, 27 Apr 2006 13:23:37 -0300 (ADT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by ranger.systems.pipex.net (Postfix) with ESMTP id 147F6E000593 for ; Thu, 27 Apr 2006 17:23:35 +0100 (BST) Received: from elliot.edesix.com ([192.168.1.51]) by flange.edesix.com with esmtp (Exim 4.50) id 1FZ9HB-0004Gx-W9 for pgsql-admin@postgresql.org; Thu, 27 Apr 2006 17:23:34 +0100 Message-ID: <4450F058.4070600@edesix.com> Date: Thu, 27 Apr 2006 17:24:56 +0100 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: New system recommendations References: <8511B4970E0D124898E973DF496F9B432515D9@stash.stackdump.local> In-Reply-To: <8511B4970E0D124898E973DF496F9B432515D9@stash.stackdump.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/310 X-Sequence-Number: 21479 >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