From: Karen Springer <karen.springer@wulfsberg.com>
To: pgsql-admin@postgresql.org
Subject: Need to upgrade postgres 7.4 to 8.1
Date: Fri, 04 Aug 2006 07:35:16 -0700
Message-ID: <44D35B24.4040503@wulfsberg.com> (raw)
In-Reply-To: <45BBA6DE339CFF41821CAF2E3314AAAA1C73CB@nea-hq-x1.nea.loc>
References: <45BBA6DE339CFF41821CAF2E3314AAAA1C73CB@nea-hq-x1.nea.loc>
I had the same problem last week. iconv cleaned up my dump file, but
removed characters I actually wanted (degree & micro symbols). I tried
changing the encoding to Latin1 in my pg_dumpall file. This did seem to
help some, though there was still a problem with some of the characters.
I finally ended up fixing the data. In our case I think the invalid
characters were created when we did transfers from Cadstar into Access &
then into Postgres. The characters were not true degree & micro UTF-8
characters, but junk that still looked ok in Access & Postgres 7.4.
Karen
JKapustik@nea.org wrote:
> Need Help. Need to upgrade our postgres 7.4 database to 8.1 in order to
> upgrade our Lyris Listmanager from 8.1 to 9. I am running into
> problems. I get invalid UTF-8 byte sequences. We are running Linux
> RedHat AS3. The database dump is 4.5 Gig. I tried the command iconv -c
> -f UTF-8 -t UTF-8 -o cleanfile postdump. It said 'file too large'.
> Note, I used postgres 8.1 pg_dump command that is recommended.. Any
> suggestions? Thanks, John
>
> John Kapustik
> Systems Administrator
> Office (202) 822 7531
> Cell (202) 285 5163
> *******************************************************************
> Only the individual sender is responsible for the content of the
> message, and the message does not necessarily reflect the position
> or policy of the National Education Association or its affiliates.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
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: karen.springer@wulfsberg.com
Subject: Re: Need to upgrade postgres 7.4 to 8.1
In-Reply-To: <44D35B24.4040503@wulfsberg.com>
References: <45BBA6DE339CFF41821CAF2E3314AAAA1C73CB@nea-hq-x1.nea.loc> <44D35B24.4040503@wulfsberg.com>
* 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