How do I access my database with pgAdmin3?
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\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.
4. Enter the following information for pgAdmin3:
a) Name (friendly name)
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.
c) Click Save
Connecting to your database using pgAdmin3 or pgAdmin4 can be useful in troubleshooting database issues that may arise.
Products using PostgreSQL for database