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