PostgreSQL with pgAdmin Package by IOanyT Innovations - Ubuntu20.04

OVERVIEW

PostgreSQL is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Windows, Linux, FreeBSD, and OpenBSD.

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.

GOALS

1. One-click launch

2. Easy configurable AMI with pre-installed PostgreSQL and pgAdmin

INSTALLATION VIA AWS MARKETPLACE

Kindly click on the below link to install the server via AWS Marketplace:

Pending ..

GET STARTED

Step 1. Connect to SSH:

1. Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.

2. In the navigation pane, choose Instances.

3. Select the instance and choose Connect.

4. Choose SSH Client

5. Copy the SSH command and paste it into the terminal.

ssh ubuntu@publicIP -i [Path of key pair file]

If it shows an access denied message run the following command, then run the above command again to connect via ssh.

chmod 400 [Path of key pair file]

Once launched in the Amazon EC2 Service, please connect to the instance via an SSH client using the ec2-user with the key pair associated at launch. Once connected as the ec2-user user, you will be able to sudo to the root user

Step 2. Configuration

Follow the below steps to configure the pgAdmin

1. Open cmd

2. Run the below command

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

3. Enter your email and password for pgAdmin

4. Open browser and enter the below URL

http://ip/pgadmin4

After Login with the email and password

To monitor and assess application functions:-

a. Navigate to your Amazon EC2 console and verify that you're in the correct region.

b. Choose Instances and select your launched instance.

c. Select the server to display your metadata page and choose the Status checks tab at the bottom of the page to review if your status checks passed or failed.

For information about how to use the application, please visit:

https://www.sqlshack.com/an-overview-of-pgadmin-postgresql-management-tool/

For detailed information about managing and requesting increased service please visit: https://docs.aws.amazon.com/general/latest/gr/aws_service_limits.html