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.
Are there any other magic options open to me?
Any way to do an in-place conversion?
I assume slony replication is an option.....
What about some sort of wal log shipping replication?
Any thoughts would be appreciated.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
