| From: | Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> |
|---|---|
| To: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Covert database from ASCII to UTF-8 |
| Date: | 2011-03-06 20:42:37 |
| Message-ID: | m2wrkcf0aq.fsf@2ndQuadrant.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Amiel <becauseimjeff(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2011-03-06 20:55:54 | Re: FTS and words near one another |
| Previous Message | Dimitri Fontaine | 2011-03-06 20:39:12 | Re: Finding Errors in .csv Input Data |