Re: Compile Source Code - Mailing list pgadmin-support
| From | Jiby James |
|---|---|
| Subject | Re: Compile Source Code |
| Date | |
| Msg-id | CAAZzyaJEiTb1em-UNwMipec-omwi_5sByCk-Skk0ong2W16XKw@mail.gmail.com Whole thread Raw |
| In response to | Re: Compile Source Code (Magnus Hagander <magnus@hagander.net>) |
| Responses |
Re: Compile Source Code
(Guillaume Lelarge <guillaume@lelarge.info>)
|
| List | pgadmin-support |
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@hagander.net> wrote:
The easiest thing on debian is to run "apt-get build-dep pgadmin3".On Thu, Jun 28, 2012 at 11:14 AM, Dave Page <dpage@pgadmin.org> wrote:
> [Please keep the mailing list CC'd]
>
> On Thu, Jun 28, 2012 at 9:36 AM, Jiby James <jamesjiby@gmail.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).
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/
pgadmin-support by date: