Re: Postfix with PostgreSQL

Tom & others:

I followed Tom's advice with no good luck. Here is what I did:

1. Installed a fresh install of CenbtOS 5.3
2. Installed PostgreSQL Client, as follows:
from: *http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Client-i386
<http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Server-i386>
*installed: *postgresql-libs-8.3.7-1PGDG.rhel5.i386.rpm
<http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Server-i386/postgresql-libs-8.3.7-1PGDG.rhel5.i386.rpm>
**postgresql-8.3.7-1PGDG.rhel5.i386.rpm
<http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Server-i386/postgresql-8.3.7-1PGDG.rhel5.i386.rpm>
**postgresql-devel-8.3.7-1PGDG.rhel5.i386.rpm
<http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Server-i386/postgresql-server-8.3.7-1PGDG.rhel5.i386.rpm>
* Nothing more for PostgreSQL.*

*3. Now I started installing 'Postfix':
Downloaded 'postfix-2.5.6.' (& extracted) into '/usr/local/src'
% cd /usr/local/src/postfix-2.5.6

======= this is actual entries on the LINUX Machine ===================
[root(at)rs1 postfix-2.5.6]# make -f Makefile.init makefiles
'CCARGS=-DHAS_PGSQL' 'AUXLIBS=-lpq'

make -f Makefile.in MAKELEVEL= Makefiles

(echo "# Do not edit -- this file documents how Postfix was built for
your machine."; /bin/sh makedefs) >makedefs.tmp

No <db.h> include file found.

Install the appropriate db*-devel package first.

See the RELEASE_NOTES file for more information.

make: *** [Makefiles] Error 1

make: *** [makefiles] Error 2

[root(at)rs1 postfix-2.5.6]#
****===================================

I guess you see the error above.

Please note that in my original post, I explained that my setup consists
of two machines; the above setup is for the machine which will host the
'Postfix' & 'PostgreSQL' client, but the PostgreSQL server is at the
back end, which will contain the data.

I know Iamdoing something wrong, but what? a NEWBIE's life is very painful!

Jennifer

PS: Once I encountered, error while installing 'Postfix', I went back &
also installed:
* **postgresql-server-8.3.7-1PGDG.rhel5.i386.rpm
<http://yum.pgsqlrpms.org/8.3/redhat/rhel-5Server-i386/postgresql-server-8.3.7-1PGDG.rhel5.i386.rpm>*

& repeated the same. Same error.

Tom Lane wrote:
> "Just E. Mail" <justemail(at)imwell-usa(dot)com> writes:
>
>> Now I am trying to install Postfix on the pgsql Client machine. Postfix
>> has the following command to 'Building Postfix with PostgreSQL support':
>>
>
>
>> % make -f Makefile.init makefiles \
>> 'CCARGS=-DHAS_PGSQL -I/usr/local/include/pgsql' \
>> 'AUXLIBS=-L/usr/local/lib -lpq'
>>
>
> If you have installed Postgres from RPMs, just make sure you've
> installed the postgresql-devel RPM too. Forget about /usr/local
> --- it should be enough to do
>
> % make -f Makefile.init makefiles \
> 'CCARGS=-DHAS_PGSQL' \
> 'AUXLIBS=-lpq'
>
> regards, tom lane
>
>