Re: initdb problem in Korean OS. - Mailing list pgsql-hackers-win32

Hi!

Could you (either one of you) please start the server with "-d 4" for debugging messages (set it to log the output to
stdoutand start the postmaster manually to capture it). We'd be interested in seeing which timezones are discarded and
whichare not.
 

It *should* pick it up automatically. But that said, we'll add something to the installer as well.

//Magnus 

> -----Original Message-----
> From: 帅猛 [mailto:shuaimeng@db.pku.edu.cn] 
> Sent: Wednesday, July 28, 2004 4:46 AM
> To: pgsql-hackers-win32@postgresql.org
> Subject: Re: [pgsql-hackers-win32] 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@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
> >>
> >
> >---------------------------(end of 
> >broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
> 
> = = = = = = = = = = = = = = = = = = = =
>             
> 
> 　　　　　　　　致
> 礼！
> 
>                 
> 　　　　　　　　帅猛
> 　　　　　　　　shuaimeng@db.pku.edu.cn
> 　　　　　　　　　　2004-07-28
> 
> 
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
>