From: | "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Invalid Byte Sequence for Encoding Error |
Date: | 2008-09-15 07:42:11 |
Message-ID: | 7f4f9efa0809150042q5589b7f2we218419e2ff7bc77@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi list,
I'm trying to migrate a database to another server. However, the source is
32-bit while the server that I'm going to have it transferred is 64-bit. Is
there any workaround on this? I'm just using a simple `pg_dump` to migrate
the database.
ENVIRONMENT:
Source DB: Linux <censored> 2.6.9-42.0.8.EL #1 Tue Jan 30 12:10:22 EST 2007
i686 i686 i386 GNU/Linuxclient - psql (PostgreSQL) 8.1.4
server - PostgreSQL 8.1.4 on i686-redhat-linux-gnu, compiled by GCC gcc
(GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
Target DB: Linux <censored> 2.6.15-28-amd64-generic #1 SMP PREEMPT Wed Jul
18 22:51:22 UTC 2007 x86_64 GNU/Linuxclient - psql (PostgreSQL) 8.2.7
server - PostgreSQL 8.2.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
And here's the error when dumping the data to the target DB:
ERROR: invalid byte sequence for encoding "UTF8": 0x80
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
Thanks in advance for your help.
Ridvan
--
リヅバン バルヨス
ridvan(dot)baluyos(at)qualservcentral(dot)com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos
Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve T | 2008-09-15 08:40:34 | Re: Invalid Byte Sequence for Encoding Error |
Previous Message | Len Shapiro | 2008-09-15 03:04:07 | GRANT question |