Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati

On Tue, 2011-08-16 at 11:58 +0200, Giuseppe Sacco wrote:
> Il giorno mar, 16/08/2011 alle 09.32 +0200, Guillaume Lelarge ha
> scritto:
> > On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote:
> > > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha
> > > scritto:
> > > > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote:
> > > [...]
> > > > Did you install the -devel package?
> > > 
> > > there is no such package:
> > > $ apt-cache search postgresql | grep -- -devel
> > > $ 
> > > 
> > 
> > Sorry, I meant libpq-dev.
> 
> Sure, libpq-dev is installed, but I still get the error. Just to recap:
> 
> List of installed packages:
> ii  libpq-dev                                     9.0.4-1+b1                        header files for libpq5 (PostgreSQL library)
> ii  libpq5                                        9.0.4-1+b1                        PostgreSQL C client library
> ii  postgresql-8.4                                8.4.8-2                           object-relational SQL database, version 8.4 server
> ii  postgresql-9.0                                9.0.4-1+b1                        object-relational SQL database, version 9.0 server
> ii  postgresql-client-8.4                         8.4.8-2                           front-end programs for PostgreSQL 8.4
> ii  postgresql-client-9.0                         9.0.4-1+b1                        front-end programs for PostgreSQL 9.0
> ii  postgresql-client-common                      119                               manager for multiple PostgreSQL client versions
> ii  postgresql-common                             119                               PostgreSQL database-cluster manager
> ii  postgresql-contrib                            9.0.4-1                           additional facilities for PostgreSQL (supported version)
> ii  postgresql-contrib-8.4                        8.4.8-2                           additional facilities for PostgreSQL
> ii  postgresql-contrib-9.0                        9.0.4-1+b1                        additional facilities for PostgreSQL
> 
> 
> The configure command, that fail, is:
> $ ./configure --prefix=/usr/local/pgadmin3-1.14  --with-pgsql=/usr/lib/postgresql/8.4
> checking build system type... i686-pc-linux-gnu
> checking host system type... i686-pc-linux-gnu
> checking for a BSD-compatible install... /usr/bin/install -c
> [...]
> checking for memmove... yes
> checking for memset... yes
> checking for strchr... yes
> configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4
>  
> Please note that it stop after strchr. If I do not specify --with-pgsql
> it goes a little bit further an change error message:
> 
> checking for memmove... yes
> checking for memset... yes
> checking for strchr... yes
> checking for SSL_library_init in -lssl... no
> checking for krb5_sendauth in -lkrb5... yes
> checking for PQexec in -lpq... no
> checking for PQconninfoParse in -lpq... no
> checking for krb5_free_principal in -lpq... no
> checking libpq-fe.h usability... yes
> checking libpq-fe.h presence... yes
> checking for libpq-fe.h... yes
> checking PostgreSQL in /usr... failed
> configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR
> 
> So, I do think the first error is wrong and should probably be somethig
> related to SSL. The second is probably looking for something different.
> 

OK, now that I got some time to install debian 6 on a VM, here are my
steps to compile pgAdmin:

# install PostgreSQL and its -dev package (-contrib is not required)
aptitude install postgresql-8.4 \                postgresql-client-8.4 \                postgresql-contrib-8.4 \                postgresql-server-dev-8.4
# install the build tools
aptitude install gcc g++ make git autoconf
# install the required libraries (wxWidgets, libxml, and libxslt)
aptitude install libwxgtk2.8-0 libwxgtk2.8-dev libxml2-dev libxslt-dev

# get the source
git clone git://git.postgresql.org/git/pgadmin3.git

# configure
./configure --prefix=/usr/local/pgadmin3-1.14

I didn't continue further as the configure step was your issue. I guess
your issue is that you don't have the postgresql-server-dev-8.4 (or
postgresql-server-dev-9.0).

Hope it helps you to solve your issues.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com