Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 22 Nov 2004 17:46:30 -0800
From:      "Ryan J. Cavicchioni" <ryan@confabulator.net>
Cc:        questions@freebsd.org
Subject:   Re: Setting up Postfix with PosgreSQLon FreeBSD
Message-ID:  <41A29676.4060601@confabulator.net>
In-Reply-To: <41A277A1.5080001@schmittnet.com>
References:  <41A24148.1000400@schmittnet.com> <41A2840D.9020104@confabulator.net> <41A277A1.5080001@schmittnet.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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@freebsd.org mailing list
>>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>>> To unsubscribe, send any mail to 
>>> "freebsd-questions-unsubscribe@freebsd.org"
>>
>>
>>
>> _______________________________________________
>> freebsd-questions@freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>> To unsubscribe, send any mail to 
>> "freebsd-questions-unsubscribe@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@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe@freebsd.org"



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41A29676.4060601>