Lab
A Cloud Guru

Deploying an Azure Database for PostgreSQL

One great advantage of the cloud is the ability to utilize Platform as a Service (PaaS) offerings to offload server and database administration, freeing you to focus on what drives success for your business. This includes your favorite open-source databases, such as PostgreSQL. In this hands-on lab scenario, you are the DBA for Awesome Company. You have been tasked with delivering an open-source database backend for a new cloud-native app. This solution should integrate closely with Azure services, allow seamless transition of developer code that has been written against PostgreSQL, and require as little hands-on maintenance as possible. Performing the actions of this lab will help you become familiar with how to provision an Azure database for PostgreSQL server.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

15m

Published

Jul 23, 2020

Challenge

Log In to the Azure Portal

Log in to the Azure Portal using the provided credentials.
Challenge

Create an Azure Database for PostgreSQL
1. Click the three-line menu icon in the top left corner of the page, and click Create a resource.
2. Click Databases.
3. Click Azure Database for PostgreSQL.
4. Under Single server, click Create.
5. Select the resource group the lab created for you.
6. Provide a server name.
7. For Location, use the same location as your lab provided Resource Group.
8. Under Compute + storage, click Configure server.
9. Click Basic.
10. Change Storage to 5 GB.
11. Set Storage Auto-growth to No.
12. Click OK.
13. Provide an admin username and password.
14. Click Review + create.
15. Verify all is well, and click Create.
16. Once the deployment is complete, click Go to resource.
Congratulations! You now have a fully operational PostgreSQL Database server that is tightly integrated with other Azure services, has its infrastructure fully managed by Microsoft, and will allow your developer data and code to be transitioned seamlessly.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.