Re: Change the place of the WAL files - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Change the place of the WAL files
Date
Msg-id dcc563d10903250833q5b778898s90298550b619e110@mail.gmail.com
Whole thread Raw
In response to Re: Change the place of the WAL files  (Nicolas Michel <nicolas.michel@lemail.be>)
Responses Re: Change the place of the WAL files  (Nicolas Michel <nicolas.michel@lemail.be>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Nicolas Michel
Date:
Subject: Re: Change the place of the WAL files
Next
From: Nicolas Michel
Date:
Subject: Re: Change the place of the WAL files