Error While Installing PGAdmin v1.20.0 for Windows

Error While Installing PGAdmin v1.20.0 for Windows

go to:

http://www.pgadmin.org/download/windows.php

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:

http://www.microsoft.com/en-us/download/details.aspx?id=40784

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.

Matt Long
1/22/2015

 

Configuring PostgreSQL for access with PGAdmin

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:

     /etc/postgresql//main

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:

/etc/init.d/postgresql restart

PGAdmin should now be able to open a connection to your database server. Log in with your postgresql username and password.

Matt 01/23/2015

Call Now Button(208) 344-1115

SIGN UP TO
GET OUR 
FREE
 APP BLUEPRINT

Join our email list

and get your free whitepaper