Package Details: pgadmin3-lts 1.23.0a-2

Git Clone URL: (read-only, click to copy)
Package Base: pgadmin3-lts
Description: Comprehensive design and management interface for PostgreSQL (LTS by BigSQL)
Upstream URL:
Licenses: custom
Conflicts: pgadmin3
Provides: pgadmin3=1.23.0a
Submitter: net147
Maintainer: dalcinandre
Last Packager: net147
Votes: 6
Popularity: 0.000113
First Submitted: 2017-01-20 01:26
Last Updated: 2017-01-25 12:46

Latest Comments

1 2 Next › Last »

jeroni commented on 2019-01-21 15:56

@dalcinandre, it seems Bigsql source code has been removed. Maybe this package makes no sense now.

jeroni commented on 2019-01-12 11:18

As I commented in pgadmin3-lts-git, the Bigsql apparently have closed source code, It's asking for Bitbucket user and password to download. Drakkan has put a new issue, but there's no answer from developers anyway...

josejorge commented on 2018-06-14 17:21

@Mayzie, the segfault problem was reported some time ago in Red Hat's bugzilla ( and seems not to be related with the use of openssl-1.0. I solved it by renaming pg_dump (yes, one of the workarounds mentioned there). Still, I can't connect to postgresql 10 servers (the reason I'm trying this pgadmin3 version).

dalcinandre commented on 2018-03-01 00:25

Hello, I solved the problem using the tip of the user nicoschl but I modified the following line;

[-f Makefile] || ./configure --prefix=/usr --with-wx-version=3.0 --with-openssl --with-libssl-prefix=$HOME/.openssl-1.0


[-f Makefile] || ./configure --prefix=/usr --with-wx-version=3.0 --with-openssl --with-libssl-prefix="${HOME}/.openssl-1.0"

because the way it was it did not compile for me.

Mayzie commented on 2018-01-31 03:43

Using that little workaround @nicoschl does not work :-/ The program just segfaults after displaying the splashscreen.

nicoschl commented on 2017-12-14 00:07


See my comment here -

A possible workaround:

1 Install OpenSSL 1.0.x

pacman -S core/openssl-1.0

2 Create a directory structure for OpenSSL 1.0.x that include both lib and include dirs.

mkdir -p $HOME/.openssl-1.0

cd $HOME/.openssl.1-0

ln -sf /usr/lib/openssl-1.0 lib

ln -sf /usr/include/openssl-1.0 include

3 Configure the build to include the new OpenSSL directory created in step 2 in the library include paths. Edit the PKGBUILD file to be:

diff --git a/PKGBUILD b/PKGBUILD

index fc2f863..d0a69ae 100644



@@ -30,7 +30,7 @@ prepare() {

build() {

cd "$srcdir/$pkgname"

  • [ -f Makefile ] || ./configure --prefix=/usr --with-wx-version=3.0

  • [ -f Makefile ] || ./configure --prefix=/usr --with-wx-version=3.0 --with-openssl --with-libssl-prefix=$HOME/.openssl-1.0



nicoschl commented on 2017-09-20 09:56

Hi guys,

Any news on the compile problems? Is there a workaround for now until it is fixed upstream maybe?

geosam commented on 2017-06-28 18:14

I get the next error:

gcc -DHAVE_CONFIG_H -I. -I.. -I../pgadmin/include/libssh2 -DDATA_DIR=\"/usr/share/pgadmin3/\" -I../pgadmin/include -I../pgadmin/include/libssh2 -D_FORTIFY_SOURCE=2 -fno-delete-null-pointer-checks -I/usr/include -I/usr/include/postgresql/server -I/usr/include/postgresql -DHAVE_CONNINFO_PARSE -I/usr/lib/wx/include/gtk2-unicode-3.0 -I/usr/include/wx-3.0 -D_FILE_OFFSET_BITS=64 -DWXUSINGDLL -D__WXGTK__ -DEMBED_XRC -I/usr/include/libxml2 -I/usr/include/libxml2 -DHAVE_OPENSSL_CRYPTO -DLIBSSH2_OPENSSL -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -MT libssh2/crypt.o -MD -MP -MF $depbase.Tpo -c -o libssh2/crypt.o libssh2/crypt.c &&\
mv -f $depbase.Tpo $depbase.Po
libssh2/crypt.c:70:25: error: field 'h' has incomplete type
_libssh2_cipher_ctx h;
make[3]: *** [Makefile:5531: libssh2/crypt.o] Error 1
make[3]: *** Waiting for unfinished jobs....
make[3]: Leaving directory '/home/samtux/makepkg/pgadmin3-lts/src/pgadmin3-lts/pgadmin'
make[2]: *** [Makefile:3568: all] Error 2
make[2]: Leaving directory '/home/samtux/makepkg/pgadmin3-lts/src/pgadmin3-lts/pgadmin'
make[1]: *** [Makefile:592: all-recursive] Error 1
make[1]: Leaving directory '/home/samtux/makepkg/pgadmin3-lts/src/pgadmin3-lts'
make: *** [Makefile:477: all] Error 2

Singularity commented on 2017-06-16 12:50

building failed for me:

depbase=`echo libssh2/crypt.o | sed 's|[^/]*$|.deps/&|;s|\.o$||'`;\
gcc -DHAVE_CONFIG_H -I. -I.. -I../pgadmin/include/libssh2 -DDATA_DIR=\"/usr/share/pgadmin3/\" -I../pgadmin/include -I../pgadmin/include/libssh2 -D_FORTIFY_SOURCE=2 -fno-delete-null-pointer-checks -I/usr/include -I/usr/include/postgresql/server -I/usr/include/postgresql -DHAVE_CONNINFO_PARSE -I/usr/lib/wx/include/gtk2-unicode-3.0 -I/usr/include/wx-3.0 -D_FILE_OFFSET_BITS=64 -DWXUSINGDLL -D__WXGTK__ -DEMBED_XRC -I/usr/include/libxml2 -I/usr/include/libxml2 -DHAVE_OPENSSL_CRYPTO -DLIBSSH2_OPENSSL -march=native -O2 -pipe -fstack-protector-strong -MT libssh2/crypt.o -MD -MP -MF $depbase.Tpo -c -o libssh2/crypt.o libssh2/crypt.c &&\
mv -f $depbase.Tpo $depbase.Po
libssh2/crypt.c:70:25: Fehler: Feld »h« hat unvollständigen Typen
_libssh2_cipher_ctx h;

net147 commented on 2017-01-23 11:00

@jeroni This package is based off the pgadmin3 package which has the same dependencies. The postgresql dependency is only required for building the package, not for installing/running the package.