Date: Mon, 22 Nov 2004 19:53:29 -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: <41A28A09.3030103@schmittnet.com> In-Reply-To: <41A29676.4060601@confabulator.net> References: <41A24148.1000400@schmittnet.com> <41A2840D.9020104@confabulator.net> <41A277A1.5080001@schmittnet.com> <41A29676.4060601@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 >> >> _______________________________________________ >> 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: > 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: > Aliasing and virtual users/domains. We're using 7.2 because we came across a few concerns (turned out to be questionable, but we had already started) about 7.2
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41A28A09.3030103>