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