Re: Compile Source Code

Magnus,

I tried to install pgadmin3(1.14) from backports. Installation was
successful, but when try to connect to the connect to the remote server, it
says

ERROR: function pg_last_xact_replay_timestamp() does not exist

LINE 1: ...SE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xa...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.

I am not getting, what it means

Thanks

Jiby
On Thu, Jun 28, 2012 at 4:20 PM, Magnus Hagander <magnus(at)hagander(dot)net>wrote:

> On Thu, Jun 28, 2012 at 11:14 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> > [Please keep the mailing list CC'd]
> >
> > On Thu, Jun 28, 2012 at 9:36 AM, Jiby James <jamesjiby(at)gmail(dot)com> wrote:
> >> Dave,
> >>
> >> I am working on a Debian 32bit squeeze version. I want to connect to a
> >> postgresql server
> >> by
> using
> >> pgadmin. But the version of pgadmin that come up with debian is
> >> not compatible to connect to the version of pstgresql installed on my
> >> server.
> >>
> >> So i downloaded source code of latest version pgadmin3-1.14.3.tar.gz.
> All
> >> the necessary dependencies are also installed.
> >>
> >> When i compile the file using ./configure, it says
> >>
> >> configure: error: Could not find your PostgreSQL installation. You might
> >> need to use the --with-pgsql=DIR configure option
> >>
> >> How can i specify remote server name in --with-pgsql option
> >
> > You cannot use a remote server when compiling. That option is used to
> > specify where to find libpq and the headers I mentioned earlier are,
> > if they cannot be found in a number of "usual" places.
> >
> > For example, if you build and install PostgreSQL with something like:
> > "./configure --prefix=/opt/postgres-9.1", then you would need to tell
> > pgAdmin the same path, eg. "./configure
> > --with-pgsql=/opt/postgres-9.1".
> >
> > Another cause of this issue is that you have PostgreSQL installed in
> > one of the default locations, but the headers for libpq are not
> > installed. Make sure you have the -devel or -dev packages installed as
> > well in that case (on Debian, I believe you need the libpq-dev
> > package).
>
> The easiest thing on debian is to run "apt-get build-dep pgadmin3".
> That will install *all* the required -devel packages, includein gother
> things like wxwidgets that are also required.
>
> And FWIW, if you just want the latest pgadmin, and don't actually
> *want* to hack it, check out backports.debian.org. It comes with
> pgadmin3 1.14 for Squeeze, pre-built and ready to use.
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
>