Jeff Amiel <becauseimj...@yahoo.com> writes: > 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.
Those blog articles of mine might be of interest to you: http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_1.html http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
