Date: Mon, 22 Nov 2004 17:46:30 -0800 From: "Ryan J. Cavicchioni" <ryan@confabulator.net> Cc: questions@freebsd.org Subject: Re: Setting up Postfix with PosgreSQLon FreeBSD Message-ID: <41A29676.4060601@confabulator.net> In-Reply-To: <41A277A1.5080001@schmittnet.com> References: <41A24148.1000400@schmittnet.com> <41A2840D.9020104@confabulator.net> <41A277A1.5080001@schmittnet.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41A29676.4060601>