trainee wrote:
> The following bug has been logged online:
> 
> Bug reference:      4694
> Logged by:          trainee
> Email address:      traine...@163.com
> PostgreSQL version: 8.3.6
> Operating system:   windows xp
> Description:        uppercase path cause postgres can't start
> Details: 
> 
> I download zip binaray 8.3.6
> extract into e:\postgres
> 
> set system variables "path"  add "E:\POSTGRES\PGSQL\BIN;" --uppercase
> 
> cmd;
> 
> pg_ctl register -N postgres -D "e:\postgres\pgdata"
> 
> when I start server , failure
> 
> error msg is :
> 
> LOG:  could not open directory "/share/timezone": No such file or directory
> FATAL:  could not select a suitable default timezone
> DETAIL:  It appears that your GMT time zone uses leap seconds. PostgreSQL
> does not support leap seconds.
> 
> if I change  system variables "path" into lowercase, success.
> 
> why?

The path has to have the same case as the directory name in the
filesystem. This is due to the fact that NTFS is case-insensitive but
case-preserving.

The recommendation is to always include the full path to the pg_ctl
command when you register the service.

That said, I have applied a patch that makes the check that fails case
insensitive, which should fix the most common cases of this happening.
It will be included in the next version (in both 8.2/8.3 and in the
upcoming 8.4)

//Magnus


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to