Question
How do I access my database with pgAdmin3 or pgAdmin4?
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\\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 pgAdmin3 or 'Add New Server' in pgAdmin4.
SCREENSHOT from pgAdmin3:
SCREENSHOT from pgAdmin4:
4. Enter the following information for pgAdmin3:
a) Name (friendly name)
b) Host
c) Port
d) Password (This will either be the Access Data Default password AD@Password or it will be one you set yourself during install)
e) Click Ok
Enter the following information for pgAdmin4:
Name: Postgres (or custom name) on General tab
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 AD@Password or a password you created during install)
d) Click 'Save'
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.
Sample paths below:
"C:\Program Files\AccessData\PostgreSQL\9.6\bin"
"C:\Program Files\AccessData\PostgreSQL\11.2\bin"
c) Click Save
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