Thread: How to move pg_xlog to another drive on Windows????
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
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
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
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