From: Scott Marlowe <scott.marlowe@gmail.com>
To: Nicolas Michel <nicolas.michel@lemail.be>
Cc: pgsql-admin@postgresql.org
Subject: Re: Change the place of the WAL files
Date: Wed, 25 Mar 2009 09:33:53 -0600
Message-ID: <dcc563d10903250833q5b778898s90298550b619e110@mail.gmail.com> (raw)
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>
On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
<nicolas.michel@lemail.be> wrote:
> Ok. Thank you.
>
>
> Le mercredi 25 mars 2009 à 15:32 +0100, Guillaume Lelarge a écrit :
>
> Le mercredi 25 mars 2009 à 14:35:36, Nicolas Michel a écrit :
>> [...]
>> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, nicolas.michel@lemail.be
Subject: Re: Change the place of the WAL files
In-Reply-To: <dcc563d10903250833q5b778898s90298550b619e110@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox