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 по дате отправления