On 03/05/2015 02:48 AM, basti wrote:
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?
Some more information is needed.
What is your OS and version?
What is version of Postgres?
How did the database get created?
What happens if you do not use -E?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
