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 (e.g. "[drive]:\Program Files\AccessData\PostgreSQL\<version>\bin")
2. Right-click pgAdmin3.exe and choose Run as administrator.
3. When the application opens, click the connection button.
4. Enter the following information:
a) Name (friendly name)
5. Click OK
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.
Connecting to your database using pgAdmin3 can be useful in troubleshooting database issues that may arise.
Products using PostgreSQL for database