Step 3: Creating an Azure Database for PostgreSQL

External databases aren’t mandatory. However, using the Azure Database for PostgreSQL will improve the scalability of your server and is recommended for deployments over 100 concurrent users.

For this demo, we will show you how to create an Azure Database for PostgreSQL to use with Teramind.

Adding the Azure Database Resource

Do the following in sequence:

1. From your Azure Portal, click All resources from the left-sidebar.
2. Click the +Add button on top.
3. From the list of options on the right side, click Databases.
4. From the right panel, click the Azure Database for PostgreSQL link.

You will be taken to the deployment option page.

Selecting a Database Plan

On the deployment option page, you will be asked how you want to use the service. Click the Create button under the Single server plan.

Launching the Database Setup Wizard

Similar to the VM Setup Wizard we used in Step 1 and the Storage Setup Wizard in Step 2, the Database Setup Wizard has several tabs on top.

On the first tab, Basics, select the Resource group you want to use. In this example, we used test as our resource group. You can also click the Create new link under it to create a new group.

Give the database a name on the Server name field. For example, myteraminddb.

Enter your admin credentials in the Admin username, Password and Confirm password fields to authenticate the account.

You can also choose the Location of your data center here.

Click the Next: Tags button when done.

Adding Tags to the Database

Tags allow you to categorize resources for consolidated billings. For this tutorial we won’t use any tags.

Click the Next: Review + create button.

Creating the Database

Azure will show you an Estimated cost per month and other details for the database on the Review + create screen.

Review all your settings and click the Create button near the bottom of the page to start creating the database.

It might take a few minutes for Azure to create the database.

Viewing Your Database

Once Azure is done, it will show the Your deployment is complete message. You can see your newly created database on the RESOURCE list.

Accessing the Connection Security Settings

Do the following in sequence:

1. From your Azure Portal, click All resources from the left-sidebar.
2. From the list of resources, select the database you just created.
3. A panel will open showing all the properties of the database. Click the Connection security link located under the Settings  group.

It will open the Connection security panel.

Configuring the Connection Security Settings

On the Connection security panel:

Turn the Allow access to Azure services option ON.

DISABLE the Enforce SSL connection option near the bottom.

Click the Save icon on top to save the changes.