Hello!
I have posted the following a week ago, but it was stalled as I was not
subscribed to pgsql-bugs. As it has not entered the list yet, I repost
after subsribing, assuming my mail has been eaten by the spam-filters.
I ported a PostgreSQL database to a new server. Dump from old server
shoulod work fine, but did not at first ..
SETUP:
======
Old server, debian Woody with postgresql backport:
-----------
test=# select version();
PostgreSQL 7.4.1 on i386-pc-linux-gnu, compiled by GCC 2.95.4
Locale = 'C'
New server, debian Sarge:
-----------
test=# select version();
PostgreSQL 7.4.2 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc
(GCC) 3.3.3 (Debian 20040401)
Locale = de_AT
Both servers:
-------------
client_encoding = LATIN1
encoding = UNICODE
I work from a console logged in with puTTY.
Now the exact same dump file worked fine on the old server, but did not
on the new.
I was confused.
What i finally found (after recovering from desparation): lc_messages is
the problem !!
Demonstration:
==============
# While running with:
lc_messages = 'de_AT'
# on the new server i tried:
(...)
postgres@dbneu:~$ psql test -f ./e_schema.sql > /dev/null
(...)
psql:./e_schema.sql:157: FEHLER: could not convert UTF-8 character
0x00fc to ISO8859-1
psql:./e_schema.sql:159: FEHLER: Relation »naehe« existiert nicht
# Many more 'could not convert UTF-8 character 0x00fc to ISO8859-1' and
friends follow. Parts of the restore fail.
# The relevant part of the dump:
...
153
154 CREATE TABLE naehe (
155 naehe_id int4 PRIMARY KEY,
156 naehe text NOT NULL
157 ) WITHOUT OIDS;
158
...
# Several tables are being created earlier in this dump, only difference
here:
# implicit creation of primary key, which triggers a notice on restore..
# This turned out to be the problem.
SOLUTION:
=========
# After editing postgresql.conf:
lc_messages = 'C'
postgres@dbneu:~$ pg_ctl reload
# .. success
postgres@dbneu:~$ psql test -f ./e_schema.sql > /dev/null
psql:./e_schema.sql:157: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "naehe_pkey" for table "naehe"
# Works fine! NO errors at all! I did not change _anything_ but
lc_messages = 'C'.
BUG?
====
There seems to be something wrong with German error messages?
I don't understand the details though.
Maybe a Debian problem? Should i file a bug there?
Thanx for considering.
Pleace cc me on replies.
Regards
Erwin Brandstetter