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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
