Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 39C489FB2FC for ; Mon, 18 Jun 2007 12:05:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 67683-02 for ; Mon, 18 Jun 2007 12:05:36 -0300 (ADT) X-Greylist: delayed 00:28:38.340218 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4E6C59FBA38 for ; Mon, 18 Jun 2007 12:05:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from power2u.goelsen.net (mail.goelsen.net [195.202.170.130]) by svr4.postgresql.org (Postfix) with ESMTP id A413C5AFB87 for ; Mon, 18 Jun 2007 14:36:59 +0000 (GMT) X-Envelope-From: michael.monnerie@it-management.at Received: from localhost (localhost [127.0.0.1]) by power2u.goelsen.net (Postfix) with ESMTP id BBCBC8214C for ; Mon, 18 Jun 2007 16:36:44 +0200 (CEST) Received: from power2u.goelsen.net ([127.0.0.1]) by localhost (power2u.goelsen.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25305-03 for ; Mon, 18 Jun 2007 16:36:21 +0200 (CEST) X-Envelope-From: michael.monnerie@it-management.at Received: from mailsrv.i.zmi.at (h081217116113.dyn.cm.kabsi.at [81.217.116.113]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mailsrv.i.zmi.at", Issuer "mailsrv.i.zmi.at" (not verified)) by power2u.goelsen.net (Postfix) with ESMTP id 4E4F981CF3 for ; Mon, 18 Jun 2007 16:36:21 +0200 (CEST) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin Subject: Converting a DB from SQL_ASCII to UTF-8 Date: Mon, 18 Jun 2007 16:36:20 +0200 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2532831.6JcpCTFZeb"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200706181636.20224@zmi.at> X-Virus-Scanned: amavisd-new at goelsen.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=AWL=-0.001, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/129 X-Sequence-Number: 25797 --nextPart2532831.6JcpCTFZeb Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Dear list, how would I convert an existing database (dbmail mail server,=20 http://dbmail.org/) from SQL_ASCII to UTF-8? I cannot just dump and reload, because: psql:/mnt/dbmail:191030: FEHLER: ung=FCltige Byte-Sequenz f=FCr=20 Kodierung =BBUTF8=AB: 0xdc62 TIP: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit=20 der Kodierung =FCbereinstimmt, die der Server erwartet, welche=20 durch =BBclient_encoding=AB bestimmt wird. (How could I tell postfix to speak with me in english?) Now what would be the correct way to convert, without destroying any of=20 the DB contents? There are e-mails there, so binary values are=20 important, too. mfg zmi =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0 --nextPart2532831.6JcpCTFZeb Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQBGdphkui0GDxxv5rARAv4jAKCkmninR3cF3UIHnC8UuvPBfY69YACeLVoS HGJDEMm4cJbobz/Iib/0/Kw= =f/3T -----END PGP SIGNATURE----- --nextPart2532831.6JcpCTFZeb--