X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 73A0C9DCBCB for ; Mon, 12 Dec 2005 12:12:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59282-07 for ; Mon, 12 Dec 2005 12:12:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 152729DCAA1 for ; Mon, 12 Dec 2005 12:12:29 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 12 Dec 2005 10:12:27 -0600 Subject: Re: separate WAL From: Scott Marlowe To: jose fuenmayor Cc: pgsql-admin@postgresql.org In-Reply-To: <69f2062a0512120808gc25aa08tcc3e31ab52b12d50@mail.gmail.com> References: <69f2062a0512120808gc25aa08tcc3e31ab52b12d50@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1134403947.3587.55.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 12 Dec 2005 10:12:27 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/94 X-Sequence-Number: 19814 On Mon, 2005-12-12 at 10:08, jose fuenmayor wrote: > How can I install pg_xlog (WAL) in another partition, i mean separate > the data directory from WAL, i have a single scsi disk with four > partitions > /, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that > by doing this occurs a boost in postgreSQL performance, thanks in > advance anyone that helps me. The basic process is this: initdb your database (I assume you've already done that.) shut down the database as the pg user, cd to $PGDATA cp -Rfp pg_xlog /some/other/vol/pg_xlog/ mv pg_xlog pg_xlog_old ln -s /some/other/vol/pg_xlog pg_xlog restart database. Note that you want the other directory set to the proper permissions (0700) and ownership (your pg user).