Re: Change the place of the WAL files

From: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Change the place of the WAL files
Date: 2009-03-25 15:41:43
Message-ID: 1237995703.6638.39.camel@nm-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Le mercredi 25 mars 2009 à 09:33 -0600, Scott Marlowe a écrit :

> On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
> <nicolas(dot)michel(at)lemail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DM 2009-03-25 19:20:08 Can we load all database objects in memory?
Previous Message Scott Marlowe 2009-03-25 15:33:53 Re: Change the place of the WAL files