There's a postgresql mailing list :D One of my former teammembers had this problem. We also have 32-bit local servers and had 64-bit production/live/deployment servers. The problem is a little less about 32-bit and 64-bit and more about encoding.
pg_dump and most of the console postgresql commands apparently uses client_encoding. I forgot this fixed but they just set some environment variables. By the way, ridvan unsa ang database encoding? UTF-8 pud? or something region-based like EUC_JP shift-JIS?? Ridvan, sa import ni cya nagka problem noh and not sa data dumping, noh? ----- Original Message ---- From: Ridvan Lakas ng Bayan S. Baluyos <[EMAIL PROTECTED]> To: Kagay-Anon Linux Users' Group (KLUG) Mailing List <[email protected]> Sent: Monday, September 15, 2008 3:55:42 PM Subject: [klug] [KLUG] invalid byte sequence for encoding problem 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/Linux client - 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
