Kickstart Azure Database For PostgreSQL

This article will walk you through creating an Azure Database for PostgreSQL on Azure portal. PostgreSQL is a powerful, open source, object-relational database system and has the capability to handle workloads ranging from small single-machine applications to large Internet-facing applications with multiple concurrent users. Azure Database for PostgreSQL is a managed service which enables you to run, manage, and scale PostgreSQL databases in the cloud.

Prerequisites

1. Microsoft Azure Subscription (MSDN subscribers or sign up for one-month free trial)

What you’ll learn

1. Creating an Azure Database for PostgreSQL.

Steps for creating the Database for PostgreSQL

1. Go to AzurePortal and sign in using Azure Subscription credentials.
2. Click on "New".
   
   
   
   
3. Select Databases from the new blade and then, select Azure Database for PostgreSQL from the Databases blade.
   
   
   
   
4. The PostgreSQL Server blade will be displayed.

1. Start up by filling the Server name.
2. Select the Subscription.
3. Create a Resource group or select an existing one.
4. Fill in the Server admin login name, password, and confirm the password.
5. Select the Location.
6. Select the Version.
   
   Note 
   Remember the Server Admin login name and password that you specify, as it will be required to log into the Server and its databases.
   

5. Click on "Pricing Tier". In the "Pricing Tier" blade, specify the service tier and performance level for your database. We are using Basic pricing tier for creating this database with 50 Compute Units and 50 GB of included storage.
   
   
   
   
6. Click on "OK".
7. Click on "Create".
   
   
   
   Note - You may put a check on "Pin to dashboard" for easy tracking of your deployment on your dashboard.

8. Click "Notifications" on the toolbar to track the deployment progress.
   
   
   
   
   

So, you can see how easy it is to get started with databases.

You have successfully deployed the Azure database for PostgreSQL on Microsoft Azure. Happy Learning !