| From: | Geoffrey Myers <geof(at)serioustechnology(dot)com> |
|---|---|
| To: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
| Cc: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Covert database from ASCII to UTF-8 |
| Date: | 2011-02-23 14:06:14 |
| Message-ID: | 4D651456.8060600@serioustechnology.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vibhor Kumar wrote:
> 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.
I'm assuming you're saying you can replicate from an ASCII database to
UTF8? What happens to the data that is not UTF8 'friendly?'
>
>> What about some sort of wal log shipping replication?
>
>
> WAL Log shipping won't help.
>
>
> Thanks & Regards,
> Vibhor Kumar
>
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2011-02-23 14:11:16 | Re: Finding Errors in .csv Input Data |
| Previous Message | Alvaro Herrera | 2011-02-23 13:46:09 | Re: How to extract a value from a record using attnum or attname? |