Follow

How Do I Use pgAdmin3 or pgAdmin4?

Created by: Justin Johns
Created date:
Last Updated date:

Question

How do I access my database with pgAdmin3?

 

Answer

Follow the steps below:

1. Navigate to the Program Files directory of the drive where Postgres was installed

"C:\Program Files\AccessData\PostgreSQL\bin" (or)
"C:\Program Files\AccessData\PostgreSQL\<version>\bin"
"C:\Program Files\AccessData\PostgreSQL\9.6\pgAdmin 4\bin"
"C:\Program Files\AccessData\PostgreSQL\11.2\pgAdmin 4\bin"

2. Right-click pgAdmin3.exe or pgAdmin4.exe and choose Run as administrator.

3. When the application opens, click the connection button in agAdmin3 or 'Add New Server' in pgAdmin4.

pgAdmin4

mceclip0.png

4. Enter the following information for pgAdmin3:

a) Name (friendly name)

b) Host

c) Port

d) Password

e) Click Ok

Enter the following information for pgAdmin4:

Name: Postgres (or custom name) on General tab

mceclip1.png

On the 'Connection' tab enter the following:

a) Host: localhost

b) Port: 5432 (or custom port if one was used)

c) Password (will either be the AccessData default password, or a password you created during install)

d) Click 'Save'

mceclip2.png

 

 

5. If the application succeeds, you should be able to expand the new connection and browse the databases, schemas, tables, etc. that are inside.  If it does not connect, an error should appear.

6. For pgAdmin 4, you will need to configure the Binary Paths before you can run maintenance.

a) File > Preferences

b) under 'Paths > Binary paths" Enter the path to the bin folder for the 9.6 or 11.2 PostgreSQL Install.

"C:\Program Files\AccessData\PostgreSQL\9.6\bin"
"C:\Program Files\AccessData\PostgreSQL\11.2\bin"

c) Click Save

mceclip3.png

 

Overview

Connecting to your database using pgAdmin3 or pgAdmin4 can be useful in troubleshooting database issues that may arise.  

 

Applies to:

Products using PostgreSQL for database

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk