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