Postgres Pro
Downloads
Home   >   mailing lists

Re: Looking for professionals for a PG server move - Mailing list pgsql-general

From Tom Lane
Subject Re: Looking for professionals for a PG server move
Date
Msg-id 14741.1262390414@sss.pgh.pa.us
Whole thread Raw
In response to Re: Looking for professionals for a PG server move  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
Tree view 
Phoenix Kiula <phoenix.kiula@gmail.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

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Looking for professionals for a PG server move
Next
From: Mark Cave-Ayland
Date:
Subject: Re: Error during make when installing geos for postgis install...still trying