pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mikel Lindsaar <raasdnil@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Anyone successfully moved the pg_xlog to a separate drive on windows server?
Date: Fri, 11 Apr 2008 17:52:48 +1000
Message-ID: <57a815bf0804110052s6e60ad56q1639f9f0451e21d6@mail.gmail.com> (raw)

Hello all,

I tried in vain last night to move the pg_xlog directory to another
drive to get some more speed out of our database.

To do this, I used linkd.exe from the Windows Server 2003 Resource
Kit.  This tool creates a 'junction' (which is the Windows term for
symlink).

However, with the pg_xlog moved to the new drive, the junction created
and able to be navigated through on the command line and explorer,
when I start up Postgres it gives an error. I put all the details in a
bug report:

  http://archives.postgresql.org/pgsql-bugs/2008-04/msg00084.php

But has anyone figured a work around on this?

I am still in negotiation with the powers that be to move over to a
BSD OS, but in the mean time I need to solve this somehow.

Any ideas?

Mikel



Message-ID: <57a815bf0804110052s6e60ad56q1639f9f0451e21d6@mail.gmail.com>
Permalink:  ../57a815bf0804110052s6e60ad56q1639f9f0451e21d6@mail.gmail.com/
Also on:    postgresql.org/message-id/57a815bf0804110052s6e60ad56q1639f9f0451e21d6@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: raasdnil@gmail.com
  Subject: Re: Anyone successfully moved the pg_xlog to a separate drive on windows server?
  In-Reply-To: <57a815bf0804110052s6e60ad56q1639f9f0451e21d6@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox