Skip site navigation (1) Skip section navigation (2)

Invalid Byte Sequence for Encoding Error

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 (view raw or flat)
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.

Responses

pgsql-novice by date

Next:From: Steve TDate: 2008-09-15 08:40:34
Subject: Re: Invalid Byte Sequence for Encoding Error
Previous:From: Len ShapiroDate: 2008-09-15 03:04:07
Subject: GRANT question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group