Microsoft Azure – Using Flexible Server in Azure Database for PostrgeSQL
In this article, we will look into the process of using the Flexible Server in the Azure Database for Postgres SQL. You can create an Azure Database for Postgres SQL with a Flexible Server which allows for configuration and control of the database server.
Let’s take a look at the below implementation. For this follow the below steps:
Step 1: In the Azure Portal, we’ll start by creating a new Azure Database for Postgres SQL.
Step 2: Here we will get the following choices, her pick Flexible Server.
Step 3: Now, select a resource group and give it a name. Then pick the Development workload type.
This pre-configures the rest of the required settings for us.
With Flexible Server, we have control over a high availability. For instance, we can tell that we want this server to use two availability zones, which increases its availability.
Let’s take a closer look at the compute and storage. Because we chose the development workload, this is preset to a Burstable compute tier which is a feature of Flexible Server. This saves costs by only increasing CPU power when we need it.
Here, we can also configure the compute and storage in more detail. We can even configure the backup retention. Let’s leave that as it is and go back.
Step 4: Now put in the admin username and now fill in the password and confirm it. We use these credentials to connect to the server.
Step 5: Click on the Next, networking. Flexible Server, enables you to put the server in a virtual network to enhance security. Here we will expose the server through the Internet with public access. When you do that, you use the firewall for security.
Step 6: Now we’ll add to blanket IP mask that allows all IP addresses to connect to the server. You shouldn’t do this in a real-world scenario, but only for development and demos.
Another feature of Flexible Server, is that it allows you to stop the server to save costs. It also enables you to configure maintenance windows. This helps you to manage downtime for your applications.
Step 7: Now we’ll connect to the created server from here in the Azure Cloud Shell. You can use any tool you prefer to connect to the server. Here, we use these commands which use the Postgres SQL.exe tool that is pre-installed in the Azure Cloud Shell. Put in my password and that’s it. We are connected to the server.
The Flexible Server option for Azure Database for Postgres SQL, allows you to customize high availability, maintenance windows, use burstable compute, and stop and start the server.