Re: Changing encoding - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Changing encoding
Date
Msg-id 200807151704.44182.peter_e@gmx.net
Whole thread Raw
In response to Changing encoding  (Carol Walter <walterc@indiana.edu>)
Responses Re: Changing encoding  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
> I have some databases that use SQL ASCII or Latin1 encoding that need
> to be UTF8.  When I have drop the database and recreated it with the
> correct encoding I get errors in restoring the data.  How is this done?

What is your PostgreSQL version?  What is the exact command sequence?

The sort of problem you describe is usually fixed by setting the client
encoding correctly, but recent versions should do this automatically for
dumps/restores.

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Changing encoding
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: More Autovacuum questions