encoding error in new Postgres version

From: "Mark Steben" <msteben(at)autorevenue(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: encoding error in new Postgres version
Date: 2009-12-15 15:58:51
Message-ID: 20091215160534.5F983632C55@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning

We recently (last month) upgraded from postgres 8.2 to 8.3.

We run linux redhat on our production servers, although a couple

Of our developers run Windows XP 32 bit. They restore a pg_dump

Copy of our production database onto their local machine.

In 8.2 they had no problem. In 8.3, however they now get the following
error

On several tables:

pg_restore: [archiver (db)] COPY failed: ERROR: character 0xe28899 of
encoding "UTF8" has no equivalent in "WIN1252"
CONTEXT: COPY emails, line 3923

I've had him change CLIIENT_ENCODING to UTF-8, then to WIN1252 all to no
avail.

I also tried running the pgdump file through the ICONV program on the linux
side before

Porting it over.

We don't have this problem in any of our linux environments.

I've attached the developer's postgresql.conf file for your reference. Any
help appreciated.

Thank you,

Mark Steben│Database Administrator

@utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Su, Alan 2009-12-15 20:29:02 Re: Looking for Good and Easy-to-use Reporting Tool
Previous Message Guillaume Lelarge 2009-12-15 07:59:52 Re: Internal fragmentations statistics Was: VACUUM FULL memory requirements