From owner-freebsd-questions@FreeBSD.ORG Tue Nov 23 03:10:03 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B41C216A4CE for ; Tue, 23 Nov 2004 03:10:03 +0000 (GMT) Received: from fulcrum.mig-29.net (dsl-200-78-45-190.prod-infinitum.com.mx [200.78.45.190]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3E7E543D45 for ; Tue, 23 Nov 2004 03:10:03 +0000 (GMT) (envelope-from mig@mig-29.net) Received: by fulcrum.mig-29.net (Postfix, from userid 1000) id 503935E811; Mon, 22 Nov 2004 21:10:02 -0600 (CST) Date: Mon, 22 Nov 2004 21:10:02 -0600 From: Manuel Rabade Garcia To: "Bill Schmitt (SW)" Message-ID: <20041123031002.GA1163@mig-29.net> References: <41A24148.1000400@schmittnet.com> <20041122182836.3cfb0524.mig@mig-29.net> <41A28AD5.90106@schmittnet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41A28AD5.90106@schmittnet.com> X-GPG-Key: 1024D/AA3325C0 2002-09-30 X-GPG-Fingerprint: D2E5 76E1 CE2D 8783 545D 1F41 399B 5765 AA33 25C0 X-MOBILE: (+52 55) 13 99 27 87 X-URL: http://mig-29.net User-Agent: Mutt/1.5.6i cc: freebsd-questions@freebsd.org Subject: Re: Setting up Postfix with PosgreSQLon FreeBSD X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Nov 2004 03:10:03 -0000 Bill Schmitt (SW), who happens to be smarter than you, thinks: > Manuel Rabade Garcia wrote: > >On Mon, 22 Nov 2004 14:43:04 -0500 > >"Bill Schmitt (SW)" wrote: > > > > > >>I've been trying to find some documentation on setting up Postfix to > >>use PostgreSQL on FreeBSD. There seems to be a lot of documentation on > >>doing it with mySQL, but I can't seem to find anything using > >>PostgreSQL. Does anyone here have any documentation, suggestions, or > >>pointers to web sites? I'm working with FBSD 4.9, PostgreSQL 7.2, and > >>Postfix 2.15. > >> > > > > > >First of all: I suggest you to use 5.3 instead of 4.9 (more support, > >more features, better preformance, etc). > > > >I have working Postfix+PostgreSQL+CyrusIMAP in FreeBSD, i read this > >tutorial: > > > >http://www.web-cyradm.org/documentation/Postfix-cyrus-postgreSQL-web-cyradm.pdf > > > >The paper talks about the setup in Linux Red Hat, but is a good > >starting point for any unix-like OS :) > > > >Greetings. > > > > Paper looks good. The reasons we stuck with 4.9 were practical. When we > started bringing up the box, 4.10 and the 5.x releases hung on the setup > of some of them. We think it was related to the presence of an unused > graphics adapter on the motherboard that kept being detected and which > we couldn't turn off on this older Gateway computer, but that is purely > a guess. > Well, upgrade is a bad idea if the machine is already in production :) In fact, the machine where i am running Postifx+Postgresql+CyrusIMAP+Alotofnicestuffformymailserver is running 4.9 :-P and it's fine and i want upgrade it in a couple of years :-D (it's a good point about FreeBSD: the security patches even for old releases ;)) If you want to apply some kind of stuff in the paper don't doubt to ask, i have running a more less similar setup as the described there :) Greetings. -- Manuel Rabade Garcia WWW - http://mig-29.net GPG - 1024D/AA3325C0 2002-09-30 Fingerprint - D2E5 76E1 CE2D 8783 545D 1F41 399B 5765 AA33 25C0