Re: upgrade from 7.4 to 8.3

Thanks Tom,

Tom Lane schreef:
> Marc Cuypers <m(dot)cuypers(at)mgvd(dot)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