Re: Looking for professionals for a PG server move

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Andy Colson <andy(at)squeakycode(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Looking for professionals for a PG server move
Date: 2010-01-02 00:00:14
Message-ID: 14741.1262390414@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> writes:
> Biggest problem is utf-8 crap. Some other databases are much more
> forgiving of the data. PG takes utf-8 data but somehow gives problem
> with backup/restore. I've tried everything, including iconv etc, but
> this truly could be a lot better in the future versions I hope.

If you want "forgiving", maybe you should run your database in SQL_ASCII
mode.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2010-01-02 08:40:42 Re: set-level update fails with unique constraint violation
Previous Message Phoenix Kiula 2010-01-01 23:42:25 Re: Looking for professionals for a PG server move