Change the place of the WAL files

--=-naOf6vVNegYf6yX6+mPY
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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,


--=-naOf6vVNegYf6yX6+mPY
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit








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,






--=-naOf6vVNegYf6yX6+mPY--

Re: Change the place of the WAL files

Le mercredi 25 mars 2009 =E0 14:35:36, Nicolas Michel a =E9crit :
> [...]
> 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.


--=20
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Change the place of the WAL files

--=-wmjIASDG/kR7JdqSsXqR
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 file=
s
> > 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 anothe=
r
> > "cleaner" way : an option in the postgres config file??
> >
>=20
> No. You really need to use a symbolic link.
>=20
>=20
> --=20
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>=20

--=-wmjIASDG/kR7JdqSsXqR
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit








Ok. Thank you.

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.

 

 

Re: Change the place of the WAL files

On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
wrote:
> Ok. Thank you.
>
>
> Le mercredi 25 mars 2009 =E0 15:32 +0100, Guillaume Lelarge a =E9crit=A0:
>
> Le mercredi 25 mars 2009 =E0 14:35:36, Nicolas Michel a =E9crit :
>> [...]
>> 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.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Change the place of the WAL files

--=-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 à 09:33 -0600, Scott Marlowe a écrit :

> On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
> 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 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








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

On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel

<> 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.