From mboxrd@z Thu Jan 1 00:00:00 1970
Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org)
by finch.gentoo.org with esmtp (Exim 4.60)
(envelope-from <gentoo-user+bounces-132749-garchives=archives.gentoo.org@lists.gentoo.org>)
id 1RdljL-0002ML-Rm
for garchives@archives.gentoo.org; Thu, 22 Dec 2011 16:42:56 +0000
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
by pigeon.gentoo.org (Postfix) with SMTP id 9B1CB21C216;
Thu, 22 Dec 2011 16:42:40 +0000 (UTC)
Received: from mail2.viabit.com (mail2.viabit.com [65.246.80.16])
by pigeon.gentoo.org (Postfix) with ESMTP id 12C7321C200
for <gentoo-user@lists.gentoo.org>; Thu, 22 Dec 2011 16:41:24 +0000 (UTC)
Received: from [10.1.1.204] (unknown [65.213.236.244])
(using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits))
(No client certificate requested)
by mail2.viabit.com (Postfix) with ESMTPSA id DB3D537ADC
for <gentoo-user@lists.gentoo.org>; Thu, 22 Dec 2011 11:41:23 -0500 (EST)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=orlitzky.com; s=mail2;
t=1324572083; bh=Sg5fL7LBdTk17V87TppV0JY9UP6ZP8ecDAWnBfSpSf0=;
h=Message-ID:Date:From:MIME-Version:To:Subject:References:
In-Reply-To:Content-Type:Content-Transfer-Encoding;
b=uSddDAnM+r/cBKKhVx8S8ac8BdRU80AT3OgtjE5rOriyaOP2h2o7sSTS3xsI8aoMm
6xh64mR0WNmRkpVCH/6h0lJ2OwrZGOGXFXFziitHTi8R5TM0Yz3kJ7jO2ZFqstc7lS
qr2h9Upus0pxe0E76X3ehCO30tY2uFRKnGpz7zyU=
Message-ID: <4EF35DB0.8060001@orlitzky.com>
Date: Thu, 22 Dec 2011 11:41:20 -0500
From: Michael Orlitzky <michael@orlitzky.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:8.0) Gecko/20111207 Thunderbird/8.0
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] switching production server from myswl to postgresql
References: <4EF23D5F.1090007@libertytrek.org>
In-Reply-To: <4EF23D5F.1090007@libertytrek.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Archives-Salt: b6e23e1d-753a-4ced-8529-1e64a4a89579
X-Archives-Hash: f9f5bba117b84caffa58a70ef6c18917
On 12/21/11 15:11, Tanstaafl wrote:
> Hi all,
>
> Ok, this has been on my ToDo list for a while, and I'm thinking of
> tacking this over the holidays, since the office will be much slower
> than usual.
>
> The only databases I have in use are for my mail server, which means
> postfix, courier-imap (soon to be dovecot 2.1 once it is released) and
> postfixadmin for maintaining the database.
>
> First question - I can run both mysql and postgresql at the same time,
> right? I haven't found anything saying I can't, and mysql doesn't seem
> to 'block' installing postgresql, so I'm guessing I can.
>
> Second question - has anyone ever converted an existing production mysql
> database to postgresql? If you have ever done this specifically for
> postfixadmin, I'd love to chat for a few minutes, but pointers to
> recent, accurate docs - even generically (not specifically for
> postfixadmin) for doing this would be appreciated.
Postfixadmin supports postgres, so you start by installing postgres
alongside your mysql installation, Next, run the postfixadmin scripts to
create the (empty) tables in your postgres database. All of the
postgres-specific stuff happens here, and postfixadmin does it for you.
After that, you just dump the mysql data, and load them into postgres.
Check out `man mysqldump` for some important options. This is the one I
remember off the top of my head:
--compatible=name
Produce output that is more compatible with other database systems
or with older MySQL servers. The value of name can be ansi,
mysql323, mysql40, postgresql...