Marc Cuypers writes:
> Can i only use nl_BE and UTF-8 now?
> Why can't i use LATIN9 anymore?
The server-side encoding has to be compatible with the locale.
(7.4 didn't really *work* in this situation, as I'm surprised
you failed to notice.)
What you can do is keep the database encoding utf8, and
Gregory Stark schreef:
Marc Cuypers writes:
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
Marc Cuypers writes:
> 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
On Wed, Mar 11, 2009 at 19:01, Marc Cuypers wrote:
> Thanks Tom,
>
> 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: encodin
Thanks Tom,
Tom Lane schreef:
Marc Cuypers 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 yo
On Tue, Mar 10, 2009 at 05:02:59PM +0100, Marc Cuypers wrote:
> Is it possible to upgrade from 7.4 to 8.3 at once?
>
> I upgraded as follows:
> when 7.4 was installed i dumped the data with:
> su postgres -c "pg_dumpall --create" > out
Just a side note in case you didn't know: It is usually
Marc Cuypers 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 LA
Hi,
I've just upgrade postgresql from 7.4 to 8.3 on a machine running debian.
And i ran in trouble. I've searched the internet but didn't find an
answer to my solution.
Is it possible to upgrade from 7.4 to 8.3 at once?
I upgraded as follows:
when 7.4 was installed i dumped the data with:
