Обсуждение: 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
Re: BUG #4101: Fails to start when transaction log on another drive
От
Euler Taveira de Oliveira
Дата:
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/