pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedChange the place of the WAL files
5+ messages / 3 participants
[nested] [flat]
* Change the place of the WAL files
@ 2009-03-25 13:35 Nicolas Michel <nicolas.michel@lemail.be>
0 siblings, 1 reply; 5+ messages in thread
From: Nicolas Michel @ 2009-03-25 13:35 UTC (permalink / raw)
To: pgsql-admin
Hi here,
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??
Thank you,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Change the place of the WAL files
@ 2009-03-25 14:32 Guillaume Lelarge <guillaume@lelarge.info>
parent: Nicolas Michel <nicolas.michel@lemail.be>
0 siblings, 1 reply; 5+ messages in thread
From: Guillaume Lelarge @ 2009-03-25 14:32 UTC (permalink / raw)
To: pgsql-admin; +Cc: Nicolas Michel <nicolas.michel@lemail.be>
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??
>
No. You really need to use a symbolic link.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Change the place of the WAL files
@ 2009-03-25 15:25 Nicolas Michel <nicolas.michel@lemail.be>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 5+ messages in thread
From: Nicolas Michel @ 2009-03-25 15:25 UTC (permalink / raw)
To: pgsql-admin
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??
> >
>
> No. You really need to use a symbolic link.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Change the place of the WAL files
@ 2009-03-25 15:33 Scott Marlowe <scott.marlowe@gmail.com>
parent: Nicolas Michel <nicolas.michel@lemail.be>
0 siblings, 1 reply; 5+ messages in thread
From: Scott Marlowe @ 2009-03-25 15:33 UTC (permalink / raw)
To: Nicolas Michel <nicolas.michel@lemail.be>; +Cc: 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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Change the place of the WAL files
@ 2009-03-25 15:41 Nicolas Michel <nicolas.michel@lemail.be>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Nicolas Michel @ 2009-03-25 15:41 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: 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.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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-03-25 15:41 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-25 13:35 Change the place of the WAL files Nicolas Michel <nicolas.michel@lemail.be>
2009-03-25 14:32 ` Guillaume Lelarge <guillaume@lelarge.info>
2009-03-25 15:25 ` Nicolas Michel <nicolas.michel@lemail.be>
2009-03-25 15:33 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-03-25 15:41 ` Nicolas Michel <nicolas.michel@lemail.be>
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