dump postgres cluster with different encodings

Поиск
Список
Период
Сортировка
Искать
От
basti
Тема
dump postgres cluster with different encodings
Дата
Msg-id
54F83466.8070803@unix-solution.de
Список
Дерево обсуждения
dump postgres cluster with different encodings basti <mailinglist@unix-solution.de>
Re: dump postgres cluster with different encodings Adrian Klaver <adrian.klaver@aklaver.com>
Re: dump postgres cluster with different encodings basti <mailinglist@unix-solution.de>
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?

В списке pgsql-general по дате отправления
От: Igor Stassiy
Дата:
От: Adrian Klaver
Дата:
FAQ