pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 8.1.3 Debian installation encoding question
6+ messages / 2 participants
[nested] [flat]
* Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-25 19:23 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 6+ messages in thread
From: Joost Kraaijeveld @ 2006-03-25 19:23 UTC (permalink / raw)
To: Debian users <debian-user@lists.debian.org>; pgsql-admin
Hi,
I was forced to reinstall PostgreSQL 8.1.3 on my Debian machine, using
the deb installation files. I used to have UTF8 or LATIN1 encoding for
the postgres, template0 and template1 databases (can't remember which
one I actualy had :-( ). But after my reinstallation I suddenly had
SQL_ASII as (default) encoding.
How can I change that? Why did the Debian encoding change? Can I still
use the Debian deb files or must I manually initdb PostgreSQL?
TIA
Joost
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-26 08:20 Peter Eisentraut <peter_e@gmx.net>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2006-03-26 08:20 UTC (permalink / raw)
To: pgsql-admin; +Cc: Joost Kraaijeveld <J.Kraaijeveld@askesis.nl>; Debian users <debian-user@lists.debian.org>
Joost Kraaijeveld wrote:
> How can I change that? Why did the Debian encoding change?
It's derived from the locale, so make sure all your locales are set up
correctly.
> Can I
> still use the Debian deb files or must I manually initdb PostgreSQL?
These options are not exclusive.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-26 09:37 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Joost Kraaijeveld @ 2006-03-26 09:37 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin@postgresql.org, Debian users <debian-user@lists.debian.org>
On Sun, 2006-03-26 at 10:20 +0200, Peter Eisentraut wrote:
> It's derived from the locale, so make sure all your locales are set up
> correctly.
OK, but how is it derived? As far as I know, I did not change anything
in the locales since the previous time I installed PostgreSQL.
My locales are:
jkr@panoramix:~$ locale
LANG=
LANGUAGE=en_US:en_GB
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=
I solved the immediate "problem" by doing an "initdb -E UTF8" but I am
not quite satisfied by that sollution: it makes the installation of
PostgreSQL more difficult for non-initiated users (including myself),
who think that a simple "apt-get install' does the right thing.
TIA
Joost
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-26 17:42 Peter Eisentraut <peter_e@gmx.net>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Eisentraut @ 2006-03-26 17:42 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@askesis.nl>; +Cc: pgsql-admin@postgresql.org, Debian users <debian-user@lists.debian.org>
Joost Kraaijeveld wrote:
> OK, but how is it derived? As far as I know, I did not change
> anything in the locales since the previous time I installed
> PostgreSQL.
If your locale is POSIX then it will choose SQL_ASCII. So there is
nothing wrong in PostgreSQL, it's just that your locale is not what you
apparently need.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-26 18:46 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 6+ messages in thread
From: Joost Kraaijeveld @ 2006-03-26 18:46 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin; Debian users <debian-user@lists.debian.org>
Peter Eisentraut wrote:
> Joost Kraaijeveld wrote:
>> OK, but how is it derived? As far as I know, I did not change
>> anything in the locales since the previous time I installed
>> PostgreSQL.
>
> If your locale is POSIX then it will choose SQL_ASCII. So there is
> nothing wrong in PostgreSQL, it's just that your locale is
> not what you apparently need.
I was certainly not implying that PostgreSQL was at fault (I wouldn't dare on a PostgreSQL mailinglist ;-) ).
But I cannot find where I have to configure what locale in the OS to get UTF8 as default encoding for the databases. (I read http://www.postgresql.org/docs/8.1/static/multibyte.html but that did not give me that info). Can you tell me this or give me a pointer to the answer?
TIA
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgresql 8.1.3 Debian installation encoding question
@ 2006-03-26 20:06 Peter Eisentraut <peter_e@gmx.net>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Eisentraut @ 2006-03-26 20:06 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@askesis.nl>; +Cc: pgsql-admin@postgresql.org, "Debian users" <debian-user@lists.debian.org>
Joost Kraaijeveld wrote:
> But I cannot find where I have to configure what locale in the OS to
> get UTF8 as default encoding for the databases. (I read
> http://www.postgresql.org/docs/8.1/static/multibyte.html but that did
> not give me that info). Can you tell me this or give me a pointer to
> the answer?
You should try something like nl_NL.utf8.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-03-26 20:06 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-25 19:23 Postgresql 8.1.3 Debian installation encoding question Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-26 08:20 ` Peter Eisentraut <peter_e@gmx.net>
2006-03-26 09:37 ` Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-26 17:42 ` Peter Eisentraut <peter_e@gmx.net>
2006-03-26 18:46 Re: Postgresql 8.1.3 Debian installation encoding question Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-26 20:06 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox