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