pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (2+ messages)

Message-ID: <44D35B24.4040503@wulfsberg.com>
Permalink:  ../44D35B24.4040503@wulfsberg.com/
Also on:    postgresql.org/message-id/44D35B24.4040503@wulfsberg.com

 · 

reply

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