Hi list, Any database administrators here or mga PostgreSQL gurus? 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 <secret> 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 <secret> 2.6.15-28-amd64-generic #1 SMP PREEMPT Wed Jul 18 22:51:22 UTC 2007 x86_64 GNU/Linux client - 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". I'll thank you later. Ridvan -- リヅバン バルヨス [EMAIL PROTECTED] 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.
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://lists.linux.org.ph/mailman/listinfo/klug) Searchable Archives: http://archives.free.net.ph
