Обсуждение: Where do I get pgAdmin 1.16 for openSuSE?

Is there a place to download pgAdmin 1.16 for openSuse (or a
repository I can add?)

All I can find is packages for 1.14, however this version is unable to
connect to Postgres 9.2 databases.  Thanks!

Mike

On 09/10/2012 09:43 PM, Mike Christensen wrote:
> Is there a place to download pgAdmin 1.16 for openSuse (or a
> repository I can add?)
>
> All I can find is packages for 1.14, however this version is unable to
> connect to Postgres 9.2 databases.  Thanks!

I could find none. You might have to build from source. I have done that in the past
and it is not to bad. See here for some tips:

http://git.postgresql.org/gitweb/?p=pgadmin3.git;a=blob;f=INSTALL;h=ac08b645c4bad6afa47e47afe9dfe45afed7156f;hb=REL-1_12_0_PATCHES

On the pgAdmin site the Source Code link points to the first Beta of 1.16.

To get the non Beta version go to:
http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0/src/

>
> Mike
>
>


--
Adrian Klaver
adrian.klaver@gmail.com

Hi,

On Mon, 2012-09-10 at 21:43 -0700, Mike Christensen wrote:
> s there a place to download pgAdmin 1.16 for openSuse (or a
> repository I can add?)
>
> All I can find is packages for 1.14, however this version is unable to
> connect to Postgres 9.2 databases.

OpenSuSE has an open build service:

https://build.opensuse.org/

You may want to submit 1.16 there, that would also help many people.

Regards
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

On Tue, Sep 11, 2012 at 6:49 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On 09/10/2012 09:43 PM, Mike Christensen wrote:
>> Is there a place to download pgAdmin 1.16 for openSuse (or a
>> repository I can add?)
>>
>> All I can find is packages for 1.14, however this version is unable to
>> connect to Postgres 9.2 databases.  Thanks!
>
> I could find none. You might have to build from source. I have done that in the past
> and it is not to bad. See here for some tips:
>
http://git.postgresql.org/gitweb/?p=pgadmin3.git;a=blob;f=INSTALL;h=ac08b645c4bad6afa47e47afe9dfe45afed7156f;hb=REL-1_12_0_PATCHES
>
> On the pgAdmin site the Source Code link points to the first Beta of 1.16.
>
> To get the non Beta version go to:
> http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0/src/

Yea, I think I'm in a bit over my head trying to build from source.
After I finally got all the dependencies worked out, I just get:


mike@dev:~/pgadmin3-1.16.0> make all
make  all-recursive
make[1]: Entering directory `/home/mike/pgadmin3-1.16.0'
Making all in xtra/png2c
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
gcc  -O2  -L/usr/local/pgsql/lib64 -Wl,-as-needed -L/usr/local/lib -o
png2c png2c.o  -L/usr/local/pgsql/lib64 -lcrypto -lpq
/usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../x86_64-suse-linux/bin/ld:
cannot find -lcrypto
collect2: ld returned 1 exit status
make[2]: *** [png2c] Error 1
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/mike/pgadmin3-1.16.0'
make: *** [all] Error 2
mike@dev:~/pgadmin3-1.16.0>

This is on openSuSE 12..

On Wed, Sep 12, 2012 at 8:43 PM, Mike Christensen <mike@kitchenpc.com> wrote:
> On Tue, Sep 11, 2012 at 6:49 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
>> On 09/10/2012 09:43 PM, Mike Christensen wrote:
>>> Is there a place to download pgAdmin 1.16 for openSuse (or a
>>> repository I can add?)
>>>
>>> All I can find is packages for 1.14, however this version is unable to
>>> connect to Postgres 9.2 databases.  Thanks!
>>
>> I could find none. You might have to build from source. I have done that in the past
>> and it is not to bad. See here for some tips:
>>
http://git.postgresql.org/gitweb/?p=pgadmin3.git;a=blob;f=INSTALL;h=ac08b645c4bad6afa47e47afe9dfe45afed7156f;hb=REL-1_12_0_PATCHES
>>
>> On the pgAdmin site the Source Code link points to the first Beta of 1.16.
>>
>> To get the non Beta version go to:
>> http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0/src/
>
> Yea, I think I'm in a bit over my head trying to build from source.
> After I finally got all the dependencies worked out, I just get:
>
>
> mike@dev:~/pgadmin3-1.16.0> make all
> make  all-recursive
> make[1]: Entering directory `/home/mike/pgadmin3-1.16.0'
> Making all in xtra/png2c
> make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
> gcc  -O2  -L/usr/local/pgsql/lib64 -Wl,-as-needed -L/usr/local/lib -o
> png2c png2c.o  -L/usr/local/pgsql/lib64 -lcrypto -lpq
> /usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../x86_64-suse-linux/bin/ld:
> cannot find -lcrypto
> collect2: ld returned 1 exit status
> make[2]: *** [png2c] Error 1
> make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/home/mike/pgadmin3-1.16.0'
> make: *** [all] Error 2
> mike@dev:~/pgadmin3-1.16.0>
>
> This is on openSuSE 12..

Okay, nevermind I fixed that one by installing the openSSL development
libraries..  However, now I just get a different error:


mike@dev:~/pgadmin3-1.16.0> make
make  all-recursive
make[1]: Entering directory `/home/mike/pgadmin3-1.16.0'
Making all in xtra/png2c
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/xtra/png2c'
Making all in branding
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/branding'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/branding'
Making all in i18n
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/i18n'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/i18n'
Making all in plugins.d
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/plugins.d'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/plugins.d'
Making all in pgadmin
make[2]: Entering directory `/home/mike/pgadmin3-1.16.0/pgadmin'
make  all-am
make[3]: Entering directory `/home/mike/pgadmin3-1.16.0/pgadmin'
g++ -DHAVE_CONFIG_H -I. -I..
-DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\"
-I../pgadmin/include   -I/usr/local/pgsql/include
-I/usr/local/pgsql/include/server -I/usr/local/pgsql/include -DSSL
-DHAVE_CONNINFO_PARSE
-I/usr/local/lib64/wx/include/gtk2-unicode-release-2.8
-I/usr/local/include/wx-2.8 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES
-D__WXGTK__ -DEMBED_XRC -I/usr/include/libxml2 -I/usr/include/libxml2
-O2 -MT pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo -c -o pgAdmin3.o
`test -f './pgAdmin3.cpp' || echo './'`./pgAdmin3.cpp
In file included from ../pgadmin/include/pgAdmin3.h:24:0,
                 from ./pgAdmin3.cpp:13:
../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
No such file or directory
compilation terminated.
make[3]: *** [pgAdmin3.o] Error 1
make[3]: Leaving directory `/home/mike/pgadmin3-1.16.0/pgadmin'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/mike/pgadmin3-1.16.0/pgadmin'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/mike/pgadmin3-1.16.0'
make: *** [all] Error 2

Hi,

On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
>                  from ./pgAdmin3.cpp:13:
> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
> No such file or directory
> compilation terminated.

Here is the buildRequires that I found on a SuSE spec for pgadmin3:

BuildRequires:  automake
BuildRequires:  gcc-c++
BuildRequires:  libopenssl-devel
BuildRequires:  libxml2-devel
BuildRequires:  libxslt-devel
BuildRequires:  postgresql-devel
BuildRequires:  update-desktop-files
BuildRequires:  wxWidgets
BuildRequires:  wxWidgets-wxcontainer-devel

So, you probably need the last two packages for the error you wrote.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

On Thu, Sep 13, 2012 at 12:15 AM, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:
>
> Hi,
>
> On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
>> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
>>                  from ./pgAdmin3.cpp:13:
>> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
>> No such file or directory
>> compilation terminated.
>
> Here is the buildRequires that I found on a SuSE spec for pgadmin3:
>
> BuildRequires:  automake
> BuildRequires:  gcc-c++
> BuildRequires:  libopenssl-devel
> BuildRequires:  libxml2-devel
> BuildRequires:  libxslt-devel
> BuildRequires:  postgresql-devel
> BuildRequires:  update-desktop-files
> BuildRequires:  wxWidgets
> BuildRequires:  wxWidgets-wxcontainer-devel

Yea, I had built wxWidgets by hand, but I guess it wasn't in the
search path or installed correctly.  I finally got around that error,
but got some other error that I wasn't able to figure out.

I think I'll just use pgAdmin on my Mac for now :)

Mike