From owner-freebsd-questions@FreeBSD.ORG  Tue Nov 23 00:28:20 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 3150316A4CE
	for <freebsd-questions@freebsd.org>;
	Tue, 23 Nov 2004 00:28:20 +0000 (GMT)
Received: from foxbat.mig-29.net (dsl-200-78-45-190.prod-infinitum.com.mx
	[200.78.45.190])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B083443D45
	for <freebsd-questions@freebsd.org>;
	Tue, 23 Nov 2004 00:28:19 +0000 (GMT)	(envelope-from mig@mig-29.net)
Received: from devel.eurorscg.com.mx (unknown [201.129.208.116])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by foxbat.mig-29.net (Postfix) with ESMTP id C2A5417022
	for <freebsd-questions@freebsd.org>;
	Mon, 22 Nov 2004 18:30:45 -0600 (CST)
Date: Mon, 22 Nov 2004 18:28:36 -0600
From: Manuel Rabade Garcia <mig@mig-29.net>
To: freebsd-questions@freebsd.org
Message-Id: <20041122182836.3cfb0524.mig@mig-29.net>
In-Reply-To: <41A24148.1000400@schmittnet.com>
References: <41A24148.1000400@schmittnet.com>
X-Mailer: Sylpheed version 0.9.12 (GTK+ 1.2.10; i386-portbld-freebsd4.9)
X-URL: http://mig-29.net
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
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 23 Nov 2004 00:28:20 -0000

On Mon, 22 Nov 2004 14:43:04 -0500
"Bill Schmitt (SW)" <software@schmittnet.com> 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.

-- 
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