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: D2631F49-71C5-4CC2-B082-D9928BE9970F@indiana.edu (view raw or flat)
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.

Carol

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-2014 The PostgreSQL Global Development Group