Thanks Tom,
Tom Lane schreef:
> Marc Cuypers <m.cuypers@mgvd.be> 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