Re: Covert database from ASCII to UTF-8

Jeff Amiel <becauseimjeff@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