Обсуждение: 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@gmail.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/