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 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
# 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
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:
Show quoted text
# 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
You can also "mount" a partition as a directory under an existing drive letter, using the "disk management" utility built-in to windows. It's not as granular as the junction method, but there's a built-in gui for it, and its more widely known and used.
-----Original Message-----
From: "Jeremy Haile" <jhaile@fastmail.fm>
To: "Roman Neuhauser" <neuhauser@sigpipe.cz>; "Karen Hill" <karen_hill22@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: 1/26/2007 12:43 PM
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/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
---------------------------(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
Import Notes
Resolved by subject fallback
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