How To Install And Configure PostgreSQL

How To Install And Configure PostgreSQL

How To Install And Configure PostgreSQL

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In this blog post, we will discuss how to install and configure PostgreSQL in different operating systems on Cloud platform like AWS, GCP or Azure.

What Is PostgreSQL:

PostgreSQL also is known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

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 Linux, FreeBSD, OpenBSD, and Windows. Most of the major cloud platform also provides PAAS version PostgreSQL as their database offering.

How To Install PostgreSQL On AWS EC2 Instance With RHEL or CentOS or Oracle Linux Version 7 AMI:

Step 1: Create an EC2 instance with any RHEL based AMI.

Step 2: Connect to your EC2 instance and update the OS packages.

Step 3: Install PostgreSQL On AWS EC2 Instance.

How To Install PostgreSQL On Google Compute Engine VM Instance With Ubuntu 18 Image:

Step 1: Create a Google Compute Engine VM instance with Ubuntu 18 Image.

Step 2: Connect to your Compute Engine VM instance.

Step 3: Install PostgreSQL On Google Compute Engine VM Instance.

How To Install PostgreSQL On Azure VM Instance With Windows Server 2012 Image:

Step 1: Create An Azure VM Instance With Windows Server 2012 Image.

Step 2: Log in to your Azure VM Instance And Download PostgreSQL Version 10 using the below link.

https://www.enterprisedb.com/postgresql-tutorial-resources-training?cid=62

Step 3: Double click on the downloaded installer package and click “Run”.

Step 4: Follow the installation wizard and complete the installation. You will be prompted for a superuser password, provide the password.

How To Install PostgreSQL On Alibaba Cloud ECS Instance With Debian Image:

Step 1: Create an Alibaba Cloud EC2 instance with Debian 10 Image.

Step 2: Connect to your ECS instance.

Step 3: Install PostgreSQL On Alibaba Cloud ECS Instance.

How To Connect To A PostgreSQL Server Using psql:

How To Configure PostgreSQL Server For 1st Time Usage:

Create A Table And Insert Some Value In Your PostgreSQL Database:

PostgreSQL psql command:

Hope you have enjoyed this blog post. Please refer below PostgreSQL documentation for more details.

https://www.postgresql.org/download/

https://www.postgresql.org/docs/10/tutorial-install.html

https://www.postgresql.org/docs/13/app-psql.html

 

Leave a Reply

Close Menu