Skip site navigation (1) Skip section navigation (2)

Re: Changing encoding

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Changing encoding
Date: 2008-07-15 15:58:48
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
I'm at 8.2.3
I do a data only pg_dump. I drop the database, then recreate it with  
the correct encoding.  Then load the data back in with psql.


On Jul 15, 2008, at 11:04 AM, Peter Eisentraut wrote:

> 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.

In response to

pgsql-admin by date

Next:From: Campbell, LanceDate: 2008-07-15 16:08:27
Subject: Backup and failover process
Previous:From: Matthew T. O'ConnorDate: 2008-07-15 15:12:30
Subject: Re: More Autovacuum questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group