Re: initdb "Fails to initialize lc_time" (using 7.3.1) - Mailing list pgsql-admin

Thanks, Tom.

Here are my steps to reproduce. Using 7.3.1 top-of-tree, on MacOS X 10.1.5,
  w/ Dev Tools April 2002 (gcc v2.95.2).

I ran the following:
0) cd pgsql
1) ./configure --prefix=/usr/local/pgsql --enable-multibyte
--enable-unicode-conversion --without-readline
2) make
3) make install
4) sudo mkdir /usr/local/pgsql/data
5) sudo chown drew /usr/local/pgsql/data
6) /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

and I get the following output from initdb:

The files belonging to this database system will be owned by user "drew".
This user must also own the server process.

The database cluster will be initialized with locale en_US.
This locale setting will prevent the use of indexes for pattern matching
operations.  If that is a concern, rerun initdb with the collation order
set to "C".  For more information see the Administrator's Guide.

Fixing permissions on existing directory data... ok
creating directory data/base... ok
creating directory data/global... ok
creating directory data/pg_xlog... ok
creating directory data/pg_clog... ok
creating template1 database in data/base/1... Failed to initialize
lc_monetaryFailed to initialize lc_numericFailed to initialize lc_timeok
creating configuration files... ok
initializing pg_shadow... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
enabling unlimited row size for system tables... Failed to initialize
lc_monetaryFailed to initialize lc_numericFailed to initialize lc_timeok
initializing pg_depend... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
creating system views... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
loading pg_description... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
creating conversions... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
setting privileges on built-in objects... Failed to initialize
lc_monetaryFailed to initialize lc_numericFailed to initialize lc_timeok
vacuuming database template1... Failed to initialize lc_monetaryFailed to
initialize lc_numericFailed to initialize lc_timeok
copying template1 to template0... Failed to initialize lc_monetaryFailed
to initialize lc_numericFailed to initialize lc_timeok

Success. You can now start the database server using:

     ./bin/postmaster -D data
or
     ./bin/pg_ctl -D data -l logfile start


Oh, and bash tells me my ENV variables are:
bash-2.05$ export
declare -x CVSROOT=":pserver:amw@src.apple.com:cvs/repository"
declare -x CVS_RSH="ssh"
declare -x HOME="/Users/drew"
declare -x HOSTNAME="il0301a-dhcp125.apple.com"
declare -x HOSTTYPE="powerpc"
declare -x JAVA_HOME="/Library/Java/Home"
declare -x LANG="en_US"
declare -x MACHTYPE="powerpc-apple-darwin1.4"
declare -x OLDPWD="/Users/drew/tools/pgsql-7.3.1-latest"
declare -x OSTYPE="darwin1.4"
declare -x PAGER="less"
declare -x PATH="/usr/bin:/bin:/Users/drew:/Developer/Tools:/usr/local/bin:
/usr/local/sbin:/sbin:/usr/sbin"
declare -x PWD="/usr/local/pgsql"
declare -x SHELL="/bin/tcsh"
declare -x SHLVL="1"
declare -x TERM="vt100"
declare -x TERMCAP="d0|vt100|vt100-am|vt100am|dec vt100:        :do=^J:co#
80:li#24:cl=\\E[;H\\E[2J:sf=2*\\ED:
:le=^H:bs:am:cm=5\\E[%i%d;%dH:nd=2\\E[C:up=2\\E[A:  :ce=3\\E[K:cd=50\\E[J:
so=2\\E[7m:se=2\\E[m:us=2\\E[4m:ue=2\\E[m:
:md=2\\E[1m:mr=2\\E[7m:mb=2\\E[5m:me=2\\E[m:        :rf=/usr/share/tabset/
vt100:    :rs=\\E>\\E[?3l\\E[?4l\\E[?5l\\E[?7h\\E[?8h\\E[;r\\E[0m\\E(B\\E)
B\\E[2J:    :ks=\\E[?1h\\E=:ke=\\E[?1l\\E>: :ku=\\EOA:kd=\\EOB:kr=\\EOC:kl=
\\EOD:kb=^H:
:ho=\\E[H:k1=\\EOP:k2=\\EOQ:k3=\\EOR:k4=\\EOS:pt:sr=2*\\EM:vt#3:xn:
:sc=\\E7:rc=\\E8:cs=\\E[%i%d;%dr:"
declare -x TERM_PROGRAM="Apple_Terminal"
declare -x TERM_PROGRAM_VERSION="57"
declare -x TOMCAT_HOME="/Users/drew/Applications/java/tomcat"
declare -x USER="drew"
declare -x __CF_USER_TEXT_ENCODING="0x1F5:0:0"


Thanks again,

Drew

On Tuesday, August 6, 2002, at 09:07 PM, Tom Lane wrote:

> Drew Wilson <amw@speakeasy.net> writes:
>> I'm getting this error "Failed to initialize lc_time" back from initdb
>> when trying to init a data directory. I'm using the latest top-of-tree
>> CVS sources.
>
> Oh?  Could we see the output from "env"?  Also, what are your configure
> options?