Re: Covert database from ASCII to UTF-8

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Covert database from ASCII to UTF-8
Date: 2011-02-22 17:03:38
Message-ID: C25BA920-5BE1-4C34-A004-48193A8F0160@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 of effort 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-02-22 17:06:14 Re: work_mem = 900MB but Sort Method: external merge Disk: 304008kB
Previous Message Andreas Kretschmer 2011-02-22 16:54:38 Re: work_mem = 900MB but Sort Method: external merge Disk: 304008kB