Managing PGAdmin4

PGAdmin 4 (https://www.pgadmin.org/) is the most popular and feature rich Open Source administration platform for PostgreSQL database. This particular AMI is pre-installed with PGAdmin to ease administration. To initialize PGAdmin 4, follow the steps below.

• Step 1: Login via SSH

$ ec2-user

$ sudo -i

$ sudo /usr/pgadmin4/bin/setup-web.sh

Follow the prompt to enter initial login details;

Your email 

Your password 

Retype password 

Wait for the installation to complete.

Enter Y (yes) to restart Apache.

• Step 2: Go to http://<your-public-ip>/pgadmin4 and enter the credentials from step 1 to login.