In this Azure tutorial, we will discuss the step-by-step guide to create Azure Database for PostgreSQL servers in Azure Portal.
Table of Contents
How to create Azure Database for PostgreSQL servers
Follow the below steps to create the Azure Database for PostgreSQL servers.
- Log in to Azure Portal.
- Search for Azure Database for PostgreSQL servers and click on the search result Azure Database for PostgreSQL servers under services.
3. On the Azure Database for PostgreSQL servers page, click on the + Create button or Create Azure Database for PostgreSQL server button.
4. Select the Resource type. The available options are single server, Flexible server (Recommended) and Azure ARC enabled PostgreSQL. Flexible server is recommended by Microsoft.
Click on the Create button.
5. On the Flexible server window, provide the below details
- Subscription: Select a valid Azure Subscription.
- Resource Group: Select an existing Resource Group or you can click on the Create new link to create a new Resource Group.
- Server name: Provide a unique name for your server.
- Region: Select the region or location.
- PostgreSQL version: Select the version for PostgreSQL.
- Workload type: Select the type of Workload as per your requirement. You have three options here i.e Development, Production (Large-size), Production (small / Medium-size).
- Compute + Storage: Click on the Configure server link to configure this option as per your requirement as an individual or as an organization.
- Availability zone: Select the availability zone 1,2, etc based on your requirement. You can also select the No preference option. This is optional.
- Enable high availability: This is optional. You can select the Enable high availability option if you wish to or leave it as it is.
- Authentication method: If you will choose the PostgreSQL authentication-only option, then you have to enter the Admin username, Password, Confirm password, etc.
If you will select the PostgreSQL and Azure Active Directory authentication option, then you have to Set Azure AD admin by clicking on the set admin link.
Once, you will click on the Set admin link, Select the AAD DC Administrators option and then click on the Select button.
Then you have to enter the Admin username, Password, Confirm password, etc.
6. Click on the Networking tab, Choose the Connectivity method as Public access (Allowed IP addresses) i.e the default option as it is.
Then you need to add atleast one firewell rule , You can click on the + Add current client IP address button or you can manually enter the Firewall rule name, Start IP address and End IP address.
If you will choose Private access (VNet Integration) option then you have to select the below options.
- Subscription: Select a valid Azure Subscription.
- Virtual network: Select a Virtual network. You can click on the Create virtual network link to create a new Virtual network or you can keep the default option as it is which will create a new virtual network for you.
- Subnet: Select a subnet or keep the default one which will create a new subnet for you that will be delegated only for the PostgreSQL flexible server use.
- Subscription: On the Private DNS integration section, Select the Azure subscription.
- Private DNS Zones: Choose the Private DNS Zone or you can leave as default which will create a new Private DNS Zone for you.
Keep the other tab options as it is and click on the Review + Create button.
It will show you all the options you have selected with all the values entered by you. You can click on the < Previous button if you wish to change any options else you can click on the Create button to create the Azure Database for PostgreSQL server.
If you missed to configure IP address in firewall rules on the Networking tab, You will get the below Pop up. You can click on the Return to add firewall rules button that will redirect you to Networking tab where you can add the firewall rule by specifying the rule name, start IP and End IP or you can click on the Create server without firewall rules to proceed with the creation of the Azure Database for PostgreSQL server.
It will take a few seconds and will show you your deployment is complete and then you can click on the Go to resource button to navigate to the Azure Database for PostgreSQL that you have created.
Here it is, you can able to see the Azure Database for PostgreSQL flexible server that I have created successfully.
Then you can check how to create a database in Azure Database for PostgreSQL flexible server.
You may also like following the below articles
- Azure PostgreSQL Single server vs Flexible server
- Azure SQL Database Vs. SQL Server
- How to backup Azure SQL database
- How To Change User Id And Password For Azure SQL Server Database
- How To Connect To Azure SQL Database
Wrapping Up
In this article, we have discussed how to create Azure Database for PostgreSQL servers. Now it’s your turn to use this information to build your own Azure Database for PostgreSQL server. Thanks for reading this article !!!