dump postgres cluster with different encodings
От | basti |
---|---|
Тема | dump postgres cluster with different encodings |
Дата | |
Msg-id | 54F83466.8070803@unix-solution.de обсуждение исходный текст |
Ответы |
Re: dump postgres cluster with different encodings
|
Список | 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?
В списке pgsql-general по дате отправления: