Follow

How Do I Use pgAdmin3?

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 (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)

b) Host

c) Port

d) Password

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.

 

Overview

Connecting to your database using pgAdmin3 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