Re: initdb problem in Korean OS.

Korea PostgreSQL Users' Group,您好！

i encountered the same problem as the KOREA friend,i think TZ should be considered in the installer:)

======= 2004-07-27 09:54:00 您在来信中写道：=======

>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(at)sollentuna(dot)net>
>To: "Korea PostgreSQL Users' Group" <pgsql-kr(at)postgresql(dot)or(dot)kr>; <pgsql-hackers-win32(at)postgresql(dot)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
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

= = = = = = = = = = = = = = = = = = = =

　　　　　　　　致
礼！

　　　　　　　　帅猛
　　　　　　　　shuaimeng(at)db(dot)pku(dot)edu(dot)cn
　　　　　　　　　　2004-07-28