Skip site navigation (1) Skip section navigation (2)

Re: Postfix with PostgreSQL

From: "Just E(dot) Mail" <justemail(at)imwell-usa(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postfix with PostgreSQL
Date: 2009-05-10 18:14:26
Message-ID: 4A071982.4060008@imwell-usa.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>   


In response to

Responses

pgsql-novice by date

Next:From: Devrim GÜNDÜZDate: 2009-05-11 10:49:46
Subject: Re: Postfix with PostgreSQL
Previous:From: Just E. MailDate: 2009-05-10 15:12:48
Subject: dbmail or dovecot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group