pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql 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>
  2006-03-26 08:20 ` Re: Postgresql 8.1.3 Debian installation encoding question Peter Eisentraut <peter_e@gmx.net>
  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-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   ` Re: Postgresql 8.1.3 Debian installation encoding question 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-25 19:23 Postgresql 8.1.3 Debian installation encoding question Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  2006-03-26 08:20 ` Re: Postgresql 8.1.3 Debian installation encoding question Peter Eisentraut <peter_e@gmx.net>
@ 2006-03-26 09:37   ` Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  2006-03-26 17:42     ` Re: Postgresql 8.1.3 Debian installation encoding question 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-25 19:23 Postgresql 8.1.3 Debian installation encoding question Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  2006-03-26 08:20 ` Re: Postgresql 8.1.3 Debian installation encoding question Peter Eisentraut <peter_e@gmx.net>
  2006-03-26 09:37   ` Re: Postgresql 8.1.3 Debian installation encoding question Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2006-03-26 17:42     ` Peter Eisentraut <peter_e@gmx.net>
  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>
  2006-03-26 20:06 ` Re: Postgresql 8.1.3 Debian installation encoding question Peter Eisentraut <peter_e@gmx.net>
  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 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>
  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