pgAdmin III is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin III is a comprehensive design and management interface for PostgreSQL database, designed to run on most operating systems. The software is written in C++ and uses the excellent wxWidgets cross platform toolkit. In every environment, pgAdmin III is a native application. The application is executed in binary code, not in a virtual machine, therefore offering excellent performance.
Let’s see how to install and configure pgAdmin in openSUSE.
NOTE: This procedure is installed on openSUSE 11.0
Pre-requisites to install pgAdmin III
pgAdmin requires the following pre-requisites to be installed before proceeding to install PostgreSQL.
Latest stable postgreSQL (YaST2 package: postgresql postgresql-devel & postgresql-server from source)
Automake (YaST2 package: automake)
Autoconf (YaST2 package: autoconf)
GNU C Compiler (YaST2 package: gcc)
wxGTK 2.8 or above (YaST2 package: wxGTK)
libxml2 & libxml2-devel
libxslt & libxslt-devel
opensuse11:~ # yast2 –install gtk2 gcc automake autoconf libxml2 libxml2-devel libxslt libxslt-devel postgresql postgresql-devel
Install PostgreSQl Database Server from Source
pgAdmin III requires Postresql database server be installed with support to openssl and hence it is better to build PostgreSQL from source.
Download PostgreSQL Source
Download the latest version of PostgreSQL from here
opensuse11:~ # wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org//source/v8.3.3/postgresql-8.3.3.tar.gz
Untar & Uncompress PostgreSQL source
opensuse11:~ # tar -zxvf postgresql-8.3.3.tar.gz
Configure/Compile & Install PostgreSQL
Change directory to the newly extracted directory and run the configure script with “–with-openssl” switch to support openssl. Once, the script runs without any error, run “make” and “make install” to compile and install PostgreSQL.
opensuse11:~ # cd postgresql-8.3.3
opensuse11:~/postgresql-8.3.3 # ./configure –with-openssl
opensuse11:~/postgresql-8.3.3 # make; make install
wxGTK2 can be installed from YaST2 packages (wxGTK) however, it is recommended to install from source. Download the latest stable release 2.8.8 of wxGTK from here
opensuse11:~ # wget http://prdownloads.sourceforge.net/wxwindows/wxGTK-2.8.8.tar.gz
Unzip & Untar wxGTK
opensuse11:~ # tar -zxvf wxGTK-2.8.8.tar.gz
Configure/Compile & Install wxGTK
opensuse11:~ # cd wxGTK-2.8.8
opensuse11:~/wxGTK-2.8.8 # ./configure –with-gtk –enable-gtk2 –enable-unicode
opensuse11:~/wxGTK-2.8.8 # make
opensuse11:~/wxGTK-2.8.8 # make install
Alternatively, pgadmin has a script to wxGTK from the downloaded source to do all the above for you. This script is “wxGTK-2.8.8/xtra/wx-build/build-wxgtk” where wxGTK-2.8.8 is the folder we extracted.
Install pgAdmin III
Let’s proceed to install pgAdmin now.
Download the latest source for pgAdmin from here
opensuse11:~ # wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org//pgadmin3/release/v1.8.4/src/pgadmin3-1.8.4.tar.gz
Unzip & Untar pgAdmin III
opensuse11:~ # tar -zxvf pgadmin3-1.8.4.tar.gz
Configure/Compile & Install pgAdmin III
opensuse11:~ # cd pgadmin3-1.8.4
opensuse11:~/pgadmin3-1.8.4 # ./configure
opensuse11:~/pgadmin3-1.8.4 # make
opensuse11:~/pgadmin3-1.8.4 # make install
This should install pgAdmin successfully on openSUSE. As I said earlier, I’ve done this in openSUSE 11.0 but should work fine on openSUSE 10.3 and earlier.
pgAdmin binaries are installed in the /usr/local/pgadmin3/bin/
To start pgAdmin run the command as
opensuse11:~ # /usr/local/pgadmin3/bin/pgadmin