Administrate PostgreSQL servers with pgAdmin

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

This documentation is valid for pgAdmin 4.5+

First application start

1. Login with the default user

2. Go to user management

3. Create a new admin user

4. Logout
5. Login with the new admin and go to user management

6. Delete default user

Add an existing server

1. Right click on Servers > Create > Server

2. In General tab, define a name for the server

3. In Connection tab, add hostname or address, username and password

4. Save configuration, the server is automatically created