Re: Can you specify the pg_xlog location from a config file?

From: "Bill Bartlett" <bbartlett(at)softwareanalytics(dot)com>
To: "'Jeremy Haile'" <jhaile(at)fastmail(dot)fm>, "'Roman Neuhauser'" <neuhauser(at)sigpipe(dot)cz>, "'Karen Hill'" <karen_hill22(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can you specify the pg_xlog location from a config file?
Date: 2007-01-26 20:50:09
Message-ID: 008c01c7418b$923adfe0$1e9617ac@bartletthome.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jeremy Haile
> Sent: Friday, January 26, 2007 1:44 PM
> To: Roman Neuhauser; Karen Hill
> Cc: pgsql-general(at)postgresql(dot)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(at)sigpipe(dot)cz> said:
> # karen_hill22(at)yahoo(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-01-26 21:06:31 Re: PostgreSQL data loss
Previous Message Jeremy Haile 2007-01-26 20:34:45 Re: Stats collector frozen?