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