How to Setup PostgreSQL Server + pgAdmin Web Tool on Ubuntu in AWS (Database Server)

How to Setup/Install PostgreSQL Server on AWS: PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. Included in this solution also comes pgAdmin, web-based management tool for PostgreSQL.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community. PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

This video will show how you can setup PostgreSQL + pgAdmin Web Tool on AWS

Enjoy the Video.

⏰Timestamps⏰
00:00 Intro to PostgreSQL server and PgAdmin Tool
00:26 Creating PostgreSQL server on Ubuntu
02:09 Accessing SSH terminal
02:41 Configuring PostgreSQL server
03:41 Accessing Postgre Shell
04:04 Running Basic Commands
04:27 Allow Remote Connections
06:13 Setup pgAdmin Tool
06:40 Accessing pgAdmin Web Tool
07:17 Outro PostgreSQL server and PgAdmin Tool on Ubuntu AWS

🔗 PostgreSQL Server + pgAdmin on Ubuntu Server 20.04 on AWS Marketplace listing:
https://aws.amazon.com/marketplace/pp...

🔗 PostgreSQL Server + pgAdmin on Debian 11 on AWS Marketplace listing:
https://aws.amazon.com/marketplace/pp...

🔗 How to Setup/Install PostgreSQL Server on AWS Blog Post:
https://cloudinfrastructureservices.c...

PostgreSQL Server Features:
-Compatible with Data Integrity
-Support multiple features of SQL
-Compatible with multiple data types
-Concurrency, Performance
-Internationalisation, Text Search
-Highly extensible
-Secure
-Highly Reliable
-pgAdmin - Web based management tool.
-Supports geospatial databases for geographic information systems (GIS).
-Robust database in the LAPP stack
-Many languages supported: Python, Java, C#, C/C+, Ruby, JavaScript (Node.js), Perl, Go, Tcl