Setting up Postfix with PosgreSQLon FreeBSD

[Ryan J. Cavicchioni]

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

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"