This is just a quick reference on how to install pgadmin 3 if the autoinstall with yum command (sudo yum install pgadmin3) fails.

Two routes would be available.

 

  1. Try running

yum list pgadmin*


If you see something like this:

that means the package is available in the highlighted repository, you'd just need to add it.

 

rpm -Uvh http://yum.postgresql.org/9.4/redhat/rhel-7-x86_64/pgdg-redhat94-9.4-3.noarch.rpm

 

After that, try sudo yum install pgadmin3_94 (insert your actual version)

 

2. If you would like a different version (or the latest one) of pgadmin, what you could do is grab the .tar.gz file from here https://www.postgresql.org/ftp/pgadmin3/release/

 

Then manually install it. For example for version 1.22.2 (the version is just for demoing purposes – I grabbed the top one available in the list):

 

mv pgadmin3-1.22.2.tar.gz /usr/local/src

cd /usr/local/src

tar –zxvf pgadmin3-1.22.2.tar.gz

cd pgadmin3-1.22.2

./configure

make

make install

 

 

Then you would need to configure your server to allow remote user access of the database using pgadmin. Two config files would need to be modified:

 

Open up the postgresql.conf configuration file.  Do a search or find for the phrase ‘listen_addresses’ without quotes.  In order to open the access up to all IP addresses change the value to a *.  The default is set to ‘localhost’ which does not allow connection from remote computers.

 

Next open the pg_hba.conf configuration file. Scroll down to the bottom of the file to the section marked # IPv4 local connections.  Add in the following code on its own line, just underneath the 127.0.0.1/32 line necessary for ‘localhost’.

host all all youripaddress/32          trust

 

This will allow for local access of the database server to the computer with the IP address you specified.  To add additional remote computers simply add a new line with their appropriate IP address.

 

Now that your configuration is complete restart the PostgreSQL database server for the changes to take effect.

 

su

su postgres

pg_ctl restart –D /usr/local/pgsql/data