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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
