Error While Installing PGAdmin v1.20.0 for Windows
Download the latest version. At the time of this post it was v1.20.0.
Unzip the file and run the .msi file.
I encountered an error after the installation when running the program to the affect of:
MSVCP120.dll is missing
This file relates to Microsoft Visual C++. The redistributable package can be found here:
After downloading and installing the x64 package (I’m running Win7 x64), I still encountered the error.
This problem was resolved by downloading and installing the x86 package.
Configuring PostgreSQL for access with PGAdmin
Download and install PGAdmin on your workstation.
At the postgresql server that you want to connect to, the configuration files for PostgreSQL are stored in:
Edit the postgesql.conf file, uncomment the line and add the server’s ip address:
listen_addresses = ‘ip_address’
ssl = true
ssl_ciphers = ALL
password_encryption = on
You can also change the default port number here with the line:
port = 5432
Make note of the port number that you use.
edit the pq_hba.conf file and include a line:
host all all 192.168.1.0/24 md5
substitute the ip address for whatever your local network uses.
If your login in PGAdmin fails, the error message may report a different ip address than what is defined in your workstation.
use the reported ip address in the pg_hba.conf file.
After making changes to the postgrsql.conf file, restart the database server:
PGAdmin should now be able to open a connection to your database server. Log in with your postgresql username and password.