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

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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings