PostgreSQL integration & setting up: an effective way

• Database: PostgreSQL
• Programming : Shell (bash), SQL
• Cloud: AWS
• OS : Linux
• Distribution : this gist works on Ubuntu 19.10 eoan (on prem'), Ubuntu 18.04 LTS (AWS)

Gist writing, testing and debugging : 12 hrs - Author : Isaac Arnault - License : MIT©, 2020

The following gist is intended to Data Architects and is part of my AWS cloud series.
It will help you start with PostgreSQL on AWS.
Since Postgres is the one of the most advanced SQL or relational databases, you may want to consider it for a professional use.
Please fork it if you find this useful.

How is gist is structured

This gist is structured into 3 parts.
You are invited to take each part one after the other.

Part 1. Deploy PostgresSQL 12 on a Linux system using AWS EC2 (back-end)
Part 2. Deploy pgadmin4 on your EC2 instance to administrate your database (front)
Part 3. Start with PostgreSQL 12 on back-end (EC2) and check your tasks on pgAdmin4 (front-end)

Few words before we start

PostgreSQL is a free and open-source powerful relational database management system (RDBMS) designed to handle many workloads, from single VMs to datawarehouses.
If you are a Data Engineer or Data Architect you may be familiar with ACID properties of relational databases.
Please note that PostgreSQL guarantees Atomicity, Consistency, Isolation and Durability of your databases.

| Some useful resources
. Encyclopedical : https://en.wikipedia.org/wiki/PostgreSQL - English
. Practical : https://waytolearnx.com/2018/11/difference-entre-mysql-et-postgresql.html - French
. Tactical : https://fr.slideshare.net/EnterpriseDB/postgresql-12-what-is-coming-up-enterprise-postgres-day - English

Related tags

• AWS
• EC2
• PostgreSQL
• Postgres
• pgAdmin4
• SQL
• RDBMS
• Cloud computing

---

About the author : Isaac Arnault is Big Data Architect, https://isaacarnault.github.io.