| 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: | Whole Thread | Raw Message | 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 |