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.
>>
>> 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
More information about the freebsd-questions
mailing list