What is PostgreSQL?
PostgreSQL, also known as Postgres, is a free and open-source relational database management system. The official PostgreSQL site mentioned, "The World's Most Advanced Open Source Relational Database". PostgreSQL as Open Source database gained huge popularity in past few years, this article post will focus how to install PostgreSQL in Azure cloud and tools to interact with the database.
Installation of PostgreSQL in the Azure Cloud environment
At first, login to your Azure portal and search for PostgreSQL, You will find different services to choose from, I have chosen “Azure Database for PostgreSQL flexible servers” from the below list as shown in Fig 1. This particular service will allow to add any extension you want to add to your database in future.
As soon as you choose the option you will find below figure 2, which will allow to create the postgreSQL flexible server.
How to connect PostgreSQL from On-Premise GUI?
And then you need to fill up the details to connect PostgreSQL database server which we deployed previously (fig 4). Details are shown in below figure 9, and fill up the information as suggested below: