How can I move pg_xlog to another drive on Windows? In Linux I can use a
symlink, but how do I that on windows?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On 12/4/06, Joost Kraaijeveld <J.Kraaijeveld@askesis.nl> wrote:
> How can I move pg_xlog to another drive on Windows? In Linux I can use a
> symlink, but how do I that on windows?

you can possibly attempt it with junction points. good luck:

http://support.microsoft.com/kb/205524

merlin

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Hmm ... I'm guessing you'd do it with a shortcut, and then rename the
ShortCut from "Shortcut to pg_xlog" to "pg_xlog".

Haven't done it with PostgreSQL, but it works with a few other programs
I've had to do that with.


--
Anthony Presley
Resolution Software
Owner/Founder
www.resolution.com

On Mon, 2006-12-04 at 18:48 +0100, Joost Kraaijeveld wrote:
> How can I move pg_xlog to another drive on Windows? In Linux I can use a
> symlink, but how do I that on windows?
>
> --
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> web: www.askesis.nl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

You can also use the freeware junction utility from
http://www.sysinternals.com as we do on Win 2K, XP and 2003.

After installing it, shutdown pg, move pg_xlog to another drive, create
junction as pg_xlog to point to new directory, then restart pg.

Cheers,
KC.

At 03:04 06/12/05, Merlin Moncure wrote:
>On 12/4/06, Joost Kraaijeveld <J.Kraaijeveld@askesis.nl> wrote:
>>How can I move pg_xlog to another drive on Windows? In Linux I can use a
>>symlink, but how do I that on windows?
>
>you can possibly attempt it with junction points. good luck:
>
>http://support.microsoft.com/kb/205524
>
>merlin
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match