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?
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 |