Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7C61A9FA418 for ; Tue, 5 Dec 2006 00:47:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 03833-06 for ; Tue, 5 Dec 2006 00:47:06 -0400 (AST) X-Greylist: delayed 00:15:53.814165 by SQLgrey-1.7.4 Received: from imsm043dat.netvigator.com (imsm043.netvigator.com [218.102.53.46]) by postgresql.org (Postfix) with ESMTP id A5F549FA18C for ; Tue, 5 Dec 2006 00:46:35 -0400 (AST) Received: from n2.netvigator.com ([203.218.166.201]) by wmail05dat.netvigator.com (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with ESMTP id <20061205040812.OFVG12563.wmail05dat.netvigator.com@n2.netvigator.com>; Tue, 5 Dec 2006 12:08:12 +0800 Received: from n2.netvigator.com ([127.0.0.1]) by [127.0.0.1] with ESMTP (SpamPal v1.594) sender ; 05 Dec 2006 12:08:12 +???? Message-Id: <6.2.1.2.0.20061205115413.03e70820@localhost> X-Mailer: QUALCOMM Windows Eudora Version 6.2.1.2 Date: Tue, 05 Dec 2006 12:02:13 +0800 To: "Joost Kraaijeveld" From: K C Lau Subject: Re: How to move pg_xlog to another drive on Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1165254499.30338.6.camel@panoramix> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/66 X-Sequence-Number: 22122 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 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