From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: dump postgres cluster with different encodings |
Date: | 2015-03-05 14:27:30 |
Message-ID: | 54F867D2.30609@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Whithout -E there was the same error.
The DB was create with:
create database "davical" WITH ENCODING = 'UTF8' LC_CTYPE='en_US.utf8' LC_COLLATE='en_US.utf8' TEMPLATE template0;
I have fix the error with
localedef -f UTF-8 -i en_US en_US.UTF-8
After a restart of postgres all is fine.
Thanks a lot.
p.s. os: debian 7 with postgres 9.1
On 05.03.2015 14:36, Adrian Klaver wrote:
> On 03/05/2015 02:48 AM, basti wrote:
>> Hello I have a postgres cluster with following databases
>>
>> davical | pgadmin | UTF8 | en_US.utf8 |
>> en_US.utf8 |
>> test | test | LATIN9 |
>> en_US.iso885915 |
>> en_US.iso885915 |
>> foo | postgres | SQL_ASCII | en_US.iso885915 |
>> en_US.iso885915 |
>>
>> when I try to dump this cluster with pg_dump or pg_dumpall I get errors
>> like:
>>
>> pg_dump -E utf8 -i -p 5432 -F c -b -v -f "davical.backup" davical
>> pg_dump: [archiver (db)] connection to database "davical" failed:
>> FATAL: database locale is incompatible with operating system
>> DETAIL: The database was initialized with LC_COLLATE "en_US.utf8",
>> which is not recognized by setlocale().
>> HINT: Recreate the database with another locale or install the missing
>> locale.
>>
>>
>> I can't connect to this database via pgadmin, there is the same error.
>>
>> locale -a
>> C
>> C.UTF-8
>> de_DE.utf8
>> en_US.iso885915
>> en_US.utf8
>> POSIX
>>
>> how can I dump this cluster? and connect to database?
>
> Some more information is needed.
>
> What is your OS and version?
>
> What is version of Postgres?
>
> How did the database get created?
>
> What happens if you do not use -E?
>
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Smith | 2015-03-05 14:39:46 | Re: Partitioning and constraint exclusion |
Previous Message | inspector morse | 2015-03-05 14:21:28 | Sharing data between stored functions? |