Logo-Transparent.png
partner-logo.png

PostgreSQL with pgAdmin Package by IOanyT Innovations - Ubuntu22.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

In a terminal window, use the ssh command to connect to the instance. You specify the user name for your instance, and the public DNS name or IPv6 address for your instance, the path and file name of the private key (.pem).


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

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

chmod 400 [Path of key pair file]


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



CONTACT

Let’s Work Together

IOanyT Innovations Pvt. Ltd.

Email: aws-marketplace-support@ioanyt.com

  • LinkedIn
  • Facebook

Thanks for submitting!