Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id CD9786379BA
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Mar 2009 12:41:54 -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 93255-06-5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Mar 2009 12:41:51 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ulysse.talessa.com (ulysse.talessa.com [85.234.192.2])
	by mail.postgresql.org (Postfix) with ESMTP id 7B236636BD9
	for <pgsql-admin@postgresql.org>; Wed, 25 Mar 2009 12:41:46 -0300 (ADT)
Received: from 57.48-244-81.adsl-dyn.isp.belgacom.be ([81.244.48.57]
	helo=[192.168.1.160]) by ulysse.talessa.com with esmtpa (Exim 4.63)
	(envelope-from <nicolas.michel@lemail.be>)
	id 1LmVEe-0001bS-JM; Wed, 25 Mar 2009 16:41:44 +0100
Subject: Re: Change the place of the WAL files
From: Nicolas Michel <nicolas.michel@lemail.be>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <dcc563d10903250833q5b778898s90298550b619e110@mail.gmail.com>
References: <1237988136.6638.26.camel@nm-laptop>
	<200903251532.02140.guillaume@lelarge.info>
	<1237994741.6638.37.camel@nm-laptop>
	<dcc563d10903250833q5b778898s90298550b619e110@mail.gmail.com>
Content-Type: multipart/alternative; boundary="=-J77+/6ZY8QMIM8Xe3ppi"
Date: Wed, 25 Mar 2009 16:41:43 +0100
Message-Id: <1237995703.6638.39.camel@nm-laptop>
Mime-Version: 1.0
X-Mailer: Evolution 2.24.3 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/225
X-Sequence-Number: 31725


--=-J77+/6ZY8QMIM8Xe3ppi
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I knew that but thank you to for your advices ;)


Le mercredi 25 mars 2009 =C3=A0 09:33 -0600, Scott Marlowe a =C3=A9crit :

> On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
> <nicolas.michel@lemail.be> wrote:
> > Ok. Thank you.
> >
> >
> > Le mercredi 25 mars 2009 =C3=A0 15:32 +0100, Guillaume Lelarge a =C3=A9=
crit :
> >
> > Le mercredi 25 mars 2009 =C3=A0 14:35:36, Nicolas Michel a =C3=A9crit :
> >> [...]
> >> I already have an instance with a database. I want to move the WAL fil=
es
> >> 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 anoth=
er
> >> "cleaner" way : an option in the postgres config file??
> >>
>=20
> 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.

--=-J77+/6ZY8QMIM8Xe3ppi
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.24.1.1">
</HEAD>
<BODY>
I knew that but thank you to for your advices ;)<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
<BR>
Le mercredi 25 mars 2009 &#224; 09:33 -0600, Scott Marlowe a &#233;crit&nbsp;:
<BLOCKQUOTE TYPE=CITE>
<PRE>
On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
&lt;<A HREF="mailto:nicolas.michel@lemail.be">nicolas.michel@lemail.be</A>&gt; wrote:
&gt; Ok. Thank you.
&gt;
&gt;
&gt; Le mercredi 25 mars 2009 &#224; 15:32 +0100, Guillaume Lelarge a &#233;crit&nbsp;:
&gt;
&gt; Le mercredi 25 mars 2009 &#224; 14:35:36, Nicolas Michel a &#233;crit :
&gt;&gt; [...]
&gt;&gt; I already have an instance with a database. I want to move the WAL files
&gt;&gt; to an other hard disk to have a better speed.
&gt;&gt; I read that I had to create a symbolic link to do that. Is there another
&gt;&gt; &quot;cleaner&quot; way : an option in the postgres config file??
&gt;&gt;

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.
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>

--=-J77+/6ZY8QMIM8Xe3ppi--