Setting up Postfix with PosgreSQLon FreeBSD
Bill Schmitt (SW)
software at schmittnet.com
Mon Nov 22 15:35:00 PST 2004
> 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.
>> freebsd-questions at freebsd.org mailing list
>> To unsubscribe, send any mail to
>> "freebsd-questions-unsubscribe at freebsd.org"
> freebsd-questions at freebsd.org mailing list
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe at freebsd.org"
Ryan J. Cavicchioni wrote:
> These instructions have always worked for me:
> The important thing is to make sure you use gmake when compiling.
> Here is a quick install that I modified to work on BSD:
> 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.
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?
More information about the freebsd-questions