pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Need to upgrade postgres 7.4 to 8.1
2+ messages / 2 participants
[nested] [flat]

* Need to upgrade postgres 7.4 to 8.1
@ 2006-08-04 13:35  JKapustik@nea.org
  0 siblings, 1 reply; 2+ messages in thread

From: JKapustik@nea.org @ 2006-08-04 13:35 UTC (permalink / raw)
  To: pgsql-admin; +Cc: StWilliams@nea.org; HBrinkley@nea.org

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Need to upgrade postgres 7.4 to 8.1
@ 2006-08-04 14:35  Karen Springer <karen.springer@wulfsberg.com>
  parent: JKapustik@nea.org
  0 siblings, 0 replies; 2+ messages in thread

From: Karen Springer @ 2006-08-04 14:35 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-08-04 14:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-04 13:35 Need to upgrade postgres 7.4 to 8.1 JKapustik@nea.org
2006-08-04 14:35 ` Karen Springer <karen.springer@wulfsberg.com>

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