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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Igor Stassiy
Дата:
Сообщение: Re: Postgres not using GiST index in a lateral join
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: can postgresql supported utf8mb4 character sets ?