Skip to main content

Deploying an Azure Database for PostgreSQL

Hands-On Lab

 

Photo of Landon Fowler

Landon Fowler

Database Training Architect II

Length

00:15:00

Difficulty

Intermediate

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.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.

Deploying an Azure Database for PostgreSQL

Introduction

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.

Log in to the Azure Portal

Log in to the Azure Portal using the provided credentials.

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. Set the following values:
    • Resource group: Select the one listed
    • Server name: Create a globally unique name
    • Location: (US) West US
    • Compute + storage: Configure server
      • Click Basic.
      • Change Storage to 5 GB.
      • Set Storage Auto-growth to No.
      • Click OK.
    • Admin username: Enter a username of your choice
    • Password: Enter a password of your choice
  6. Click Review + create.
  7. Verify all is well, and click Create.
  8. Once the deployment is complete (it should just take a couple minutes), click Go to resource to view it.

Conclusion

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.