From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <gnomik@mtv.ru>
From: Andrew Nazarkin <gnomik@mtv.ru>
Organization: MTV Russia
To: sisyphus@altlinux.ru
Subject: Re: [sisyphus] Postgresql =?koi8-r?b?zsU=?= =?koi8-r?b?INPUwdLU1cXU?=
Date: Wed, 21 May 2003 17:46:02 +0400
User-Agent: KMail/1.5.1
References: <200305211624.40421.gnomik@mtv.ru> <200305211702.01249.gnomik@mtv.ru> <200305211730.05246.serpiph@entek.ru>
In-Reply-To: <200305211730.05246.serpiph@entek.ru>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="koi8-r"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Message-Id: <200305211746.02402.gnomik@mtv.ru>
Sender: sisyphus-admin@altlinux.ru
Errors-To: sisyphus-admin@altlinux.ru
X-BeenThere: sisyphus@altlinux.ru
X-Mailman-Version: 2.0.9
Precedence: bulk
Reply-To: sisyphus@altlinux.ru
X-Reply-To: gnomik@mtv.ru
List-Unsubscribe: <http://altlinux.ru/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@altlinux.ru?subject=unsubscribe>
List-Id: <sisyphus.altlinux.ru>
List-Post: <mailto:sisyphus@altlinux.ru>
List-Help: <mailto:sisyphus-request@altlinux.ru?subject=help>
List-Subscribe: <http://altlinux.ru/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@altlinux.ru?subject=subscribe>
List-Archive: <http://altlinux.ru/pipermail/sisyphus/>
Archived-At: <http://lore.altlinux.org/sisyphus/200305211746.02402.gnomik@mtv.ru/>
List-Archive: <http://lore.altlinux.org/sisyphus/>

В сообщении от 21 Май 2003 17:29 Епифанов Сергей написал:
> В сообщении от 21 Май 2003 17:02 Andrew Nazarkin написал:
> > > touch /etc/localtime
> >
> > Нифига ((
>
> Давайте смотреть в файл /etc/chroot.d/postgresql.*
>
> Есть ли у вас такие файлы:
..skip..

Да, дело, похоже в локали. 
initdb от юзера постгрес выдает вот такие ошибки:

initdb --locale=C
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.

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

Под тем же юзеом postgres:

-bash-2.05b$ locale
LANG=ru_RU.KOI8-R
LC_CTYPE=ru_RU.KOI8-R
LC_NUMERIC=ru_RU.KOI8-R
LC_TIME=ru_RU.KOI8-R
LC_COLLATE=ru_RU.KOI8-R
LC_MONETARY=ru_RU.KOI8-R
LC_MESSAGES=ru_RU.KOI8-R
LC_PAPER="ru_RU.KOI8-R"
LC_NAME="ru_RU.KOI8-R"
LC_ADDRESS="ru_RU.KOI8-R"
LC_TELEPHONE="ru_RU.KOI8-R"
LC_MEASUREMENT="ru_RU.KOI8-R"
LC_IDENTIFICATION="ru_RU.KOI8-R"
LC_ALL=

Буду разбираться с локалью...

-- 
With Best Regards
Andrew N. Nazarkin