Postgres Pro
Downloads
Home   >   mailing lists

Re: Covert database from ASCII to UTF-8 - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: Covert database from ASCII to UTF-8
Date
Msg-id C25BA920-5BE1-4C34-A004-48193A8F0160@enterprisedb.com
Whole thread Raw
In response to Covert database from ASCII to UTF-8  (Jeff Amiel <becauseimjeff@yahoo.com>)
Responses Re: Covert database from ASCII to UTF-8  (Geoffrey Myers <geof@serioustechnology.com>)
List pgsql-general
Tree view 
On Feb 22, 2011, at 10:23 PM, Jeff Amiel wrote:

> It's come time to bite the bullet and convert a half-terraybyte database from ASCII to UTF8.  Have gone through a bit
ofeffort to track down the unclean ascii text and repair it but would like to avoid the outage of a many-many hour
dump-restore.
>
> Using Postgres 8.4.X.
>
> I assume slony replication is an option.....

Right! Replication would help. You can also try Bucardo.

> What about some sort of wal log shipping replication?


WAL Log shipping won't help.


Thanks & Regards,
Vibhor Kumar

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: work_mem = 900MB but Sort Method: external merge Disk: 304008kB
Next
From: Vick Khera
Date:
Subject: Re: Covert database from ASCII to UTF-8