Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 52E5B64FCB1 for ; Mon, 17 Nov 2008 06:49:40 -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 04501-07-3 for ; Mon, 17 Nov 2008 06:49:36 -0400 (AST) X-Greylist: delayed 00:14:23.02915 by SQLgrey-1.7.6 Received: from mail.transporeon-hq.com (mail.transporeon-hq.com [213.179.145.36]) by mail.postgresql.org (Postfix) with ESMTP id E22EF65014E for ; Mon, 17 Nov 2008 06:49:35 -0400 (AST) Received: from localhost ([127.0.0.1]) by mail.transporeon-hq.com with esmtp (Exim 4.69) (envelope-from ) id 1L21Rj-0000bY-KK for pgsql-admin@postgresql.org; Mon, 17 Nov 2008 11:35:07 +0100 X-Virus-Scanned: Scanned by transporeon.com Received: from mail.transporeon-hq.com ([127.0.0.1]) by localhost (mail.transporeon.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id L8xV9dd0VHuK for ; Mon, 17 Nov 2008 11:35:05 +0100 (CET) Received: from gw.transporeon-hq.com ([213.179.145.34] helo=[172.28.8.2]) by mail.transporeon-hq.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1L21Rg-0000bD-Rc for pgsql-admin@postgresql.org; Mon, 17 Nov 2008 11:35:05 +0100 Message-ID: <492148D7.80207@transporeon.com> Date: Mon, 17 Nov 2008 11:35:03 +0100 From: =?ISO-8859-2?Q?Gerd_K=F6nig?= User-Agent: Thunderbird 2.0.0.17 (X11/20080914) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: move from mysql to postgresql X-Enigmail-Version: 0.95.7 OpenPGP: id=CE188E9F Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit 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: 200811/82 X-Sequence-Number: 30736 Hello, we're going to switch from mysql (ver. 5.0.26) to PostgreSQL (OS: opensuse 10.3). The mysql database includes several instances, and we only want to migrate the bugzilla instance to Postgres (yes, it's the bugzilla backend...). What are the preferred steps to perform this migration ? ("cost free" solutions are highly appreciated ;-) ). thanks in advance ...GERD...