Setting up Postfix with PosgreSQLon FreeBSD

[Ryan J. Cavicchioni]

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 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
>
> _______________________________________________
> 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"