I had below message when I executed initdb command without setting TZ environment variable.
D:\msys\local\pgsql>bin\initdb -D data
The files belonging to this database system will be owned by user "films".
This user must also own the server process.
The database cluster will be initialized with locale Korean_Korea.949.
creating directory data ... ok
creating directory data/global ... ok
creating directory data/pg_xlog ... ok
creating directory data/pg_xlog/archive_status ... ok
creating directory data/pg_clog ... ok
creating directory data/pg_subtrans ... ok
creating directory data/base ... ok
creating directory data/base/1 ... ok
creating directory data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in data/base/1 ... 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.
child process was terminated by signal 1
initdb: failed
initdb: removing data directory "data"
---------------
but, I successed to make database cluster with below command
> set TZ=Asia/Seoul
> initdb -D data --no-locale
--------------
I had above error messages in install temp log file to use Win32 GUI installer.
This problem is initdb can't set default TZ value without set TZ environment variable in Korean language OS.
(There are a same problem too in CJK language OS.)
----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Korea PostgreSQL Users' Group" <pgsql-kr@postgresql.or.kr>; <pgsql-hackers-win32@postgresql.org>
Sent: Monday, July 26, 2004 5:14 PM
Subject: RE: [pgsql-hackers-win32] PostgreSQL Win32 GUI installer beta
> Really? That sounds more like an issue in the TZ library, though - it
> should manage without a TZ env var. Or are you just saying that it picks
> up the wrong timezone?
>
> Can you run initdb manually without the TZ environment variable set and
> get the same error? And what is the actual error?
>
> //Magnus
>
