Thanks Tom,
Tom Lane schreef:
Marc Cuypers <m.cuypers@xxxxxxx> writes:
Databases in 7.4 were encoded as utf-8. Now when importing postgresql
gives the following error:
ERROR: encoding UTF8 does not match server's locale en_US
DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
It looks like you need to run initdb with LANG set to en_US.utf8,
not just en_US.
I executed the command:
su postgres -c "/usr/lib/postgresql/8.3/bin/initdb -E UNICODE --locale
nl_BE.utf8 -D /home/pgsql/8"
And now i can use utf-8.
Only...
One database was in LATIN9. When creating this database i got the same
error.
Command:
CREATE DATABASE "hardsoft" WITH OWNER = postgres TEMPLATE = template0
ENCODING = 'LATIN9';
Error:
ERROR: encoding LATIN9 does not match server's locale nl_BE.utf8
SQL state: XX000
Detail: The server's LC_CTYPE setting requires encoding UTF8.
Can i only use nl_BE and UTF-8 now?
Why can't i use LATIN9 anymore?
Is bacula 8.3 stricter in this respect to 7.4?
--
best regards,
Marc
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
