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