From: Benjamin Krajmalnik <kraj@illumen.com>
To: pgsql admin <pgsql-admin@postgresql.org>
Subject: Strange UTF8 issue with pg_dump/pg_restore
Date: Mon, 7 Aug 2006 20:08:23 -0600
Message-ID: <BF337097BDD9D849A2F4B818DDB279872525AB@stash.stackdump.local> (raw)
I have a database whose records are inserted via ODBC.
I turned on logging, and the client is explicitly setting the client
encoding to UTF.
Rows are inserted into the tables. When I do a pg_dump, I do not get
any errors. When I try tor restore, I am getting an error regarding an
invalid UTF-8 character sequence.
Of course, this renders compressed backups useless, since I have no way
of manually fixing the file. The process of fixing the file is, of
course, painful.
Is this a known issue? I am running PG 8.1.4. The problem happened on
PG Windows.
Tomorrow I will try to see if the problem exists in the FreeBSD compile.
If I get it to reproduce, I will be able to send some data dumps, but
will need to know who to send it to.
Regards,
Benjamin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kraj@illumen.com
Subject: Re: Strange UTF8 issue with pg_dump/pg_restore
In-Reply-To: <BF337097BDD9D849A2F4B818DDB279872525AB@stash.stackdump.local>
References: <BF337097BDD9D849A2F4B818DDB279872525AB@stash.stackdump.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox