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

Re: unicode

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: unicode
Date: 2005-06-30 11:26:11
Message-ID: 42c3cee1$0$22365$8fe63b2a@news.disputo.net (view raw or flat)
Thread:
Lists: pgsql-admin
> I hear that FreeBSD doesn't support Unicode, so you're probably out of luck 
> for now.

Hm, but the locales are there, it's just named de_DE.UTF-8 instead of 
de_DE.utf8 on FreeBSD. InitDB crashs with the following:

[pgsql(at)kirk pgsql]$initdb --locale=de_DE.UTF-8
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

The database cluster will be initialized with locale de_DE.UTF-8.
The default database encoding has accordingly been set to UNICODE.

fixing permissions on existing directory /opt/pgsql/data ... ok
creating directory /opt/pgsql/data/global ... ok
creating directory /opt/pgsql/data/pg_xlog ... ok
creating directory /opt/pgsql/data/pg_xlog/archive_status ... ok
creating directory /opt/pgsql/data/pg_clog ... ok
creating directory /opt/pgsql/data/pg_subtrans ... ok
creating directory /opt/pgsql/data/base ... ok
creating directory /opt/pgsql/data/base/1 ... ok
creating directory /opt/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /opt/pgsql/data/base/1 ... FATAL:  XX000: 
failed to initialize lc_messages to ""
LOCATION:  InitializeGUCOptions, guc.c:2389
child process exited with exit code 1
initdb: removing contents of data directory "/opt/pgsql/data"
[pgsql(at)kirk pgsql]$

-- 
imos  Gesellschaft fuer Internet-Marketing und Online-Services mbH
Alfons-Feifel-Str. 9 // D-73037 Goeppingen  // Stauferpark Ost
Tel: 07161 93339-14 // Fax: 07161 93339-99 // Internet: www.imos.net

In response to

  • Re: unicode at 2005-06-30 10:54:06 from Peter Eisentraut

Responses

pgsql-admin by date

Next:From: manikeshwari prasad bohidarDate: 2005-06-30 13:52:49
Subject: Query on pg_dump
Previous:From: jehan-freeDate: 2005-06-30 10:57:18
Subject: Re: restore database from bare files

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