database-inspection.md

Database Inspection

There are number of ways to log into a running database instance. This document describes how to log into and browse a PostgreSQL database.

pgAdmin

Define login details and launch pgAdmin:

export PG_USERNAME='user@domain.com'
export PG_PASSWORD='PgadminUserPassword'
./bin/pgadmin.py --detach

Connect to the database

1. Visit http://localhost:5050.
2. Log in with the login details defined above.
3. Press Add New Server.
4. General tab
   1. Name: <name_of_the_item>
5. Connection tab
   1. Host name/address: <hostname>, e.g. localhost, or Docker database container name
   2. Port: usually 5432
   3. Username: <superuser_username>
   4. Password: <superuser_password>
6. Press Save. The Postgres server should now be ready for browsing.

Longer explanation of the above steps and configuration can be found in the pgAdmin documentation.