Skip site navigation (1) Skip section navigation (2)

Re: initdb problem in Korean OS.

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "??" <shuaimeng(at)db(dot)pku(dot)edu(dot)cn>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: initdb problem in Korean OS.
Date: 2004-07-28 07:53:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE34BF44@algol.sollentuna.se (view raw or flat)
Thread:
Lists: 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 stdout and start the postmaster manually to capture it). We'd be interested in seeing which timezones are discarded and which are 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(at)db(dot)pku(dot)edu(dot)cn] 
> Sent: Wednesday, July 28, 2004 4:46 AM
> To: pgsql-hackers-win32(at)postgresql(dot)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(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
> 
> 
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 

Responses

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-07-28 07:56:45
Subject: Re: win32 pgsql not installable
Previous:From: Magnus HaganderDate: 2004-07-28 07:49:07
Subject: Re: win32 pgsql not installable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group