Re: problem start database

Hi,

On Tue, 20 Sep 2005, Ing. Jhon Carrillo - Caracas, Venezuela wrote:

> i have a problem when i run the initdb file, do you know anything?
>
> bash-2.05b$ /usr/lib/postgresql/bin/initdb -D /var/lib/pgsql/data
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.

<snipped>

> creating directory /var/lib/pgsql/data/pg_tblspc ... ok
> selecting default max_connections ... 10
> selecting default shared_buffers ... 50
> creating configuration files ... ok
> creating template1 database in /var/lib/pgsql/data/base/1 ... FATAL: XX000:
> failed to initialize lc_messages to ""
> LOCATION: InitializeGUCOptions, guc.c:2389

This reminded me a bug that was fixed in 7.4.2. Are you using 7.4 or
7.4.1?

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-bugs-owner(at)postgresql(dot)org Wed Sep 21 13:14:53 2005
X-Original-To: pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 30E38D99C0
for <pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 21 Sep 2005 12:30:04 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 09822-05
for <pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 21 Sep 2005 15:29:52 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
by svr1.postgresql.org (Postfix) with ESMTP id D6F4AD9AB5
for <pgsql-bugs(at)postgresql(dot)org>; Wed, 21 Sep 2005 12:24:44 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])
by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8LFOboK014710;
Wed, 21 Sep 2005 11:24:37 -0400 (EDT)
To: "Ing. Jhon Carrillo - Caracas, Venezuela" <jdigital(at)cantv(dot)net>
Cc: "Wade Hampton" <wade(dot)hampton(at)nsc1(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem start database
In-reply-to: <043901c5bde4$daaf93a0$1400a8c0(at)tgusta2>
References: <20050919181855(dot)E3CFCF0B77(at)svr2(dot)postgresql(dot)org> <6734(dot)1127230866(at)sss(dot)pgh(dot)pa(dot)us> <043901c5bde4$daaf93a0$1400a8c0(at)tgusta2>
Comments: In-reply-to "Ing. Jhon Carrillo - Caracas, Venezuela" <jdigital(at)cantv(dot)net>
message dated "Tue, 20 Sep 2005 09:11:42 -0400"
Date: Wed, 21 Sep 2005 11:24:37 -0400
Message-ID: <14709(dot)1127316277(at)sss(dot)pgh(dot)pa(dot)us>
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
X-Archive-Number: 200509/136
X-Sequence-Number: 12876

"Ing. Jhon Carrillo - Caracas, Venezuela" <jdigital(at)cantv(dot)net> writes:
> creating template1 database in /var/lib/pgsql/data/base/1 ... FATAL: XX000:
> failed to initialize lc_messages to ""

What PG version is this exactly, what platform are you running it on,
and what locale environment are you running initdb in? (For the last
question, show the output of "locale", or if you don't have that
program then "env | grep ^L".)

regards, tom lane