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@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@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@imwell-usa.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
>
>