Re: [GENERAL] dump postgres cluster with different encodings

2015-03-05 Thread basti
Whithout -E there was the same error. The DB was create with: create database "davical" WITH ENCODING = 'UTF8' LC_CTYPE='en_US.utf8' LC_COLLATE='en_US.utf8' TEMPLATE template0; I have fix the error with localedef -f UTF-8 -i en_US en_US.UTF-8 After a restart of postgres all is fine. Thanks a

Re: [GENERAL] dump postgres cluster with different encodings

2015-03-05 Thread Adrian Klaver
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