Setting up Postfix with PosgreSQLon FreeBSD

[Bill Schmitt (SW)]

> 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 at freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>> To unsubscribe, send any mail to 
>> "freebsd-questions-unsubscribe at freebsd.org"
> 
> 
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe at 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