Re: BUG #4101: Fails to start when transaction log on another drive

The following bug has been logged online:

Bug reference: 4101
Logged by: Mikel Lindsaar
Email address: raasdnil(at)gmail(dot)com
PostgreSQL version: 8.3.1
Operating system: Windows Server 2003
Description: Fails to start when transaction log on another drive
Details:

Fresh install of PostgreSQL 8.3.1. Complete the install and shutdown the
server.

Install Postgres into C:\Program Files\PostgreSQL\8.3, install data into
D:\PostgreSQL\8.3\data

Move the contents of pg_xlog directory to C:\Program
Files\PostgreSQL\8.3\transation_log\pg_xlog\

Remove D:\PostgreSQL\8.3\data\pg_xlog

Then use linkd.exe from Windows Server 2003 Resource kit to make a Junction
(windows symlink) of the pg_xlog directory to another drive using:

linkd d:\PostgreSQL\8.3\data\pg_xlog "C:\Program
Files\PostgreSQL\transaction_log\pg_xlog"

Start postgres service

Get the following error in the application event log after the server fails
to start:

Faulting application postgres.exe version 8.3.1.876 faulting module
postgres.exe, version 8.3.1.876 fault address 0x00249229

Type: Error, Category (100)

I have uninstalled and reinstalled 8.3 and tried again, same failure. Have
not tried with 8.2

Regards

Mikel

Mikel Lindsaar wrote:

> linkd d:\PostgreSQL\8.3\data\pg_xlog "C:\Program
> Files\PostgreSQL\transaction_log\pg_xlog"
>
^^^^^^^^^^^^^^^^
The correct xlog path is $PGDATA\pg_xlog. Normally, it is 'C:\Program
Files\PostgreSQL\X.X\data\pg_xlog'.

--
Euler Taveira de Oliveira
http://www.timbira.com/