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