Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DD4A563677A for ; Wed, 25 Mar 2009 12:34:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 91676-06 for ; Wed, 25 Mar 2009 12:33:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.26]) by mail.postgresql.org (Postfix) with ESMTP id DE7506362B7 for ; Wed, 25 Mar 2009 12:33:56 -0300 (ADT) Received: by ey-out-2122.google.com with SMTP id 22so17592eye.61 for ; Wed, 25 Mar 2009 08:33:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=Uhge5QOb8nv6ayy+8ZN74RuxWtOfD8z4zU2J/AhAwEM=; b=RusT14nUkfvybheevqh42cHoLpTs8/ipDnLZSJ/w3hECv9boQx5eJueZCCNK45WKfd osXvp1whGilAbBzgP75i4BSkc0cHrAN01/o1cwAYeLr0viculdfwT6XNSp+da2uN5qnT ffu04pRxAg+VcyDghpBN6K47uTHrf9BTP30Tw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=GfzS0y8mIM/1/HedFG9LgjmYWJ5TCLAZxM7ofBytfXzovbh0N4ERyIAPv0x/twJSa4 Adu44pfbD+6dKlyf/YBv6y0BsxFFR68I1z6nAbonDo5vABfykVPYVkSkxDqiCS1k95eC yXWcEjFuC61FL/Aqzs+kbOQpOSLBUkKlGjc0g= MIME-Version: 1.0 Received: by 10.210.135.17 with SMTP id i17mr4193797ebd.87.1237995233457; Wed, 25 Mar 2009 08:33:53 -0700 (PDT) In-Reply-To: <1237994741.6638.37.camel@nm-laptop> References: <1237988136.6638.26.camel@nm-laptop> <200903251532.02140.guillaume@lelarge.info> <1237994741.6638.37.camel@nm-laptop> Date: Wed, 25 Mar 2009 09:33:53 -0600 Message-ID: Subject: Re: Change the place of the WAL files From: Scott Marlowe To: Nicolas Michel Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/224 X-Sequence-Number: 31724 On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel wrote: > Ok. Thank you. > > > Le mercredi 25 mars 2009 =E0 15:32 +0100, Guillaume Lelarge a =E9crit=A0: > > Le mercredi 25 mars 2009 =E0 14:35:36, Nicolas Michel a =E9crit : >> [...] >> I already have an instance with a database. I want to move the WAL files >> to an other hard disk to have a better speed. >> I read that I had to create a symbolic link to do that. Is there another >> "cleaner" way : an option in the postgres config file?? >> Note that you need to shutdown the db, copy the files, move / remove the pg_xlog dir, link to the new one, and restart the db. I.e. the DB has to be shutdown while you do this. I'm sure you know this, but better safe than sorry.