From owner-freebsd-questions@FreeBSD.ORG Mon Nov 22 23:46:24 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 A55B716A4CE for ; Mon, 22 Nov 2004 23:46:24 +0000 (GMT) Received: from relay01.pair.com (relay01.pair.com [209.68.5.15]) by mx1.FreeBSD.org (Postfix) with SMTP id 02E0343D31 for ; Mon, 22 Nov 2004 23:46:23 +0000 (GMT) (envelope-from ryan@confabulator.net) Received: (qmail 35811 invoked from network); 22 Nov 2004 23:46:22 -0000 Received: from unknown (HELO ?192.168.0.83?) (unknown) by unknown with SMTP; 22 Nov 2004 23:46:22 -0000 X-pair-Authenticated: 209.197.24.213 Message-ID: <41A29676.4060601@confabulator.net> Date: Mon, 22 Nov 2004 17:46:30 -0800 From: "Ryan J. Cavicchioni" User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <41A24148.1000400@schmittnet.com> <41A2840D.9020104@confabulator.net> <41A277A1.5080001@schmittnet.com> In-Reply-To: <41A277A1.5080001@schmittnet.com> 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:46:24 -0000 What is Postfix using PostgreSQL for? Is there a reason why you are not using the most current version of PostgreSQL? Bill Schmitt (SW) wrote: >> 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 > > _______________________________________________ > 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"