How to Create Azure Database for PostgreSQL Servers in Microsoft Azure

Azure Database for PostgreSQL is a relational database service in the Microsoft cloud based on the PostgreSQL Community Edition (available under the GPLv2 license) database engine.

Azure Database for PostgreSQL delivers:

  1. Built-in high availability.
  2. Data protection using automatic backups and point-in-time-restore for up to 35 days.
  3. Database engine to keep the service secure and up to date.
  4. Predictable performance, using inclusive pay-as-you-go pricing.
  5. Monitoring and automation to simplify management and monitoring for large-scale deployments.
  6. Industry-leading support experience.

 

  • Login to azure portal
  • Click on All Services.
  • Select Azure Database for PostgreSQL Servers.

 

Fig 1

 

  • Click on Create.

 

Fig 2

 

  • Select  an option Azure Database for PostgreSQL deployment.
  • If Select Single Server then click on Create option.

 

Fig. 3

 

  • On Basics tab provide the following values:-

 

  • Subscription: An Azure subscription grants you access to Azure services.
  • Resource group name: A resource group is a collection of resources.
  • Provide the Server name.
  • Select Data Source (Set the backup for PostgreSQL server).
  • Select Location & PostgreSQL Version.
  • Select compute + Storage plan as per requirements.
  • Provide the Administrator details like admin username & password.
  • Click on Next Additional Settings.

 

Fig. 4Fig. 5

 

  • At Additional setting add a second layer of encryption for your data using a different encryption algorithm which gives additional data protection
  • Click on Tags.

 

Fig. 6

 

  • On Tags Tab provide the tag name and value for Azure Database for PostgreSQL Server.
  • Click Next on Review + Create.

 

Fig. 7

 

  • If you get a message “Validation passed”.
  • Then click on Create.

Fig. 8

 

  • After some time, you will see a message as “Your deployment is ready”.
  • Click on “Go to resources” & You can see that the Azure Database for PostgreSQL Server is there with the name we provide.

Leave a Reply