Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 64DEB632630; Thu, 29 Jan 2009 11:16:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83474-04; Thu, 29 Jan 2009 11:16:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id BCFE66325C5; Thu, 29 Jan 2009 11:16:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n0TFGG3j028818; Thu, 29 Jan 2009 10:16:16 -0500 (EST) To: "Moshe Ben-Shoham" cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Encoding problem using pg_dumpall In-reply-to: <75E4C42D37E6A74E9FB57C2E9F1300D60107073E@tiger.nexperience.com> References: <75E4C42D37E6A74E9FB57C2E9F1300D60107073E@tiger.nexperience.com> Comments: In-reply-to "Moshe Ben-Shoham" message dated "Thu, 29 Jan 2009 13:50:11 +0200" Date: Thu, 29 Jan 2009 10:16:16 -0500 Message-ID: <28817.1233242176@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/158 X-Sequence-Number: 31205 "Moshe Ben-Shoham" writes: > C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall -U admint > > c:\temp\dbdump.sql > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: character 0xd595 of encoding > "UTF8" has no equivalent in "WIN1252" Apparently you have WIN1252 set as the default client encoding, probably via an environment variable or locale setting. Either get rid of it, or override it by including "-E UTF8" in the pg_dump command. (Hmm, actually it looks like pg_dumpall hasn't got a -E switch, which seems like an oversight. So you need to fix your locale, or else use pg_dump directly.) regards, tom lane