From owner-freebsd-questions@FreeBSD.ORG Mon Nov 22 23:35:00 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 BB75716A4CF for ; Mon, 22 Nov 2004 23:35:00 +0000 (GMT) Received: from idesigns.net (idesigns.net [209.239.38.159]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5703243D2D for ; Mon, 22 Nov 2004 23:35:00 +0000 (GMT) (envelope-from software@schmittnet.com) Received: from [127.0.0.1] (ct-seymour2d-19.wtrbct.adelphia.net [68.71.172.19]) by idesigns.net (8.12.10/8.12.10) with ESMTP id iAMNYvgC007937; Mon, 22 Nov 2004 18:34:59 -0500 Message-ID: <41A277A1.5080001@schmittnet.com> Date: Mon, 22 Nov 2004 18:34:57 -0500 From: "Bill Schmitt (SW)" User-Agent: Mozilla Thunderbird 0.6+ (Windows/20041018) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Ryan J. Cavicchioni" References: <41A24148.1000400@schmittnet.com> <41A2840D.9020104@confabulator.net> In-Reply-To: <41A2840D.9020104@confabulator.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit cc: 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: Mon, 22 Nov 2004 23:35:00 -0000 > 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. >> >> TIA, >> >> Bill >> >> >> _______________________________________________ >> freebsd-questions@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-questions >> To unsubscribe, send any mail to >> "freebsd-questions-unsubscribe@freebsd.org" > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > > Ryan J. Cavicchioni wrote: > Bill, > > These instructions have always worked for me: > http://www.postgresql.org/docs/7.2/static/installation.html > > The important thing is to make sure you use gmake when compiling. > > Here is a quick install that I modified to work on BSD: > > ./configure > gmake > su > gmake install > pw useradd postgres > mkdir /usr/local/pgsql/data > chown postgres /usr/local/pgsql/data > su postgres > /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & > /usr/local/pgsql/bin/createdb test > /usr/local/pgsql/bin/psql test > > I hope that this helps. > > Regards, > Ryan > Thanks for responding, Ryan, but I'm confused. I have managed to start postgres with a user I called pgsql. The install appears to do that with a user called postgres but doesn't reference postfix. How do I tell postfix that I want to use postgres? Thanks Bill