Thread: Can you specify the pg_xlog location from a config file?
Windows doesn't support symlinks. Is it possible instead for there to be a config file that lets one set where the pg_xlog directory will sit?
# karen_hill22@yahoo.com / 2007-01-26 09:21:27 -0800: > Windows doesn't support symlinks. Is it possible instead for there to > be a config file that lets one set where the pg_xlog directory will sit? Windows has junction points. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991
Karen Hill wrote: > Windows doesn't support symlinks. Is it possible instead for there to > be a config file that lets one set where the pg_xlog directory will sit? > You can use a junction point for this instead of a symlink. Google for utilities to create them. Regards, Dave.
"Karen Hill" <karen_hill22@yahoo.com> writes:
> Windows doesn't support symlinks.
Yes it does, at least in reasonably modern versions. They're called
"junctions" or something like that.
regards, tom lane
This utility is useful for creating junctions in Windows: http://www.microsoft.com/technet/sysinternals/FileAndDisk/Junction.mspx I am using this to "symlink" my pg_xlog directory to another disk and it works great. Jeremy Haile On Fri, 26 Jan 2007 18:27:04 +0000, "Roman Neuhauser" <neuhauser@sigpipe.cz> said: > # karen_hill22@yahoo.com / 2007-01-26 09:21:27 -0800: > > Windows doesn't support symlinks. Is it possible instead for there to > > be a config file that lets one set where the pg_xlog directory will sit? > > Windows has junction points. > > -- > How many Vietnam vets does it take to screw in a light bulb? > You don't know, man. You don't KNOW. > Cause you weren't THERE. http://bash.org/?255991 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
The Windows Server 2003 Resource Kit and WinXP Resource Kit (both free to download) both also provide the LINKD utility -- we use LINKD to create junctions on most of our Windows servers (to mimic the equivalent hard links we use on our Linux servers). - Bill > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jeremy Haile > Sent: Friday, January 26, 2007 1:44 PM > To: Roman Neuhauser; Karen Hill > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Can you specify the pg_xlog location > from a config file? > > > This utility is useful for creating junctions in Windows: > http://www.microsoft.com/technet/sysinternals/FileAndDisk/Junc tion.mspx I am using this to "symlink" my pg_xlog directory to another disk and it works great. Jeremy Haile On Fri, 26 Jan 2007 18:27:04 +0000, "Roman Neuhauser" <neuhauser@sigpipe.cz> said: > # karen_hill22@yahoo.com / 2007-01-26 09:21:27 -0800: > > Windows doesn't support symlinks. Is it possible instead for there > > to be a config file that lets one set where the pg_xlog directory > > will sit? > > Windows has junction points. > > -- > How many Vietnam vets does it take to screw in a light bulb? > You don't know, man. You don't KNOW. > Cause you weren't THERE. http://bash.org/?255991 > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly