dump postgres cluster with different encodings

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: dump postgres cluster with different encodings
Date: 2015-03-05 10:48:06
Message-ID: 54F83466.8070803@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-03-05 13:25:09 Re: can postgresql supported utf8mb4 character sets ?
Previous Message Elena Fernandez Carmona 2015-03-05 10:27:10 compatibilty postgres 9.2 RHEL 6.4