Thread: Compile Source Code

On Thu, Jun 28, 2012 at 8:55 AM, Jiby James <jamesjiby@gmail.com> wrote:
> Sir,
>
> How to provide remote postgresql server name while compiling from  source
> code of pgAdmin

You can't - you give the name of the server you wish to manage at
runtime. At compile time, you must have libpq (and the associated
headers) on the build machine.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

[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).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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).

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/

On Fri, 2012-06-29 at 13:29 +0530, Jiby James wrote:
> 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
> 

Which version of PostgreSQL do you use?


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