Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-13 Thread Devrim GÜNDÜZ

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


signature.asc
Description: This is a digitally signed message part


Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-13 Thread Mike Christensen
On Thu, Sep 13, 2012 at 12:15 AM, Devrim GÜNDÜZ dev...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-12 Thread Mike Christensen
On Tue, Sep 11, 2012 at 6:49 AM, Adrian Klaver adrian.kla...@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..


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-12 Thread Mike Christensen
On Wed, Sep 12, 2012 at 8:43 PM, Mike Christensen m...@kitchenpc.com wrote:
 On Tue, Sep 11, 2012 at 6:49 AM, Adrian Klaver adrian.kla...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-11 Thread Adrian Klaver
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.kla...@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-11 Thread Alexander Reichstadt
Also, you could try the enterprise package, it does have the pgAdmin and 
probably every other bit you could have a need for now or later:

http://enterprisedb.com/downloads/postgres-postgresql-downloads

The installer walks you through all the subpackages and you can confirm for 
each if you want it or not.


Am 11.09.2012 um 15:49 schrieb Adrian Klaver:

 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.kla...@gmail.com
 
 
 -- 
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general



Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-11 Thread Devrim GÜNDÜZ

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


signature.asc
Description: This is a digitally signed message part


[GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-10 Thread Mike Christensen
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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general