PostgreSQL database deployment with knowledge transfer to on-premises DBAs team using Microsoft Azure Database for PostgreSQL Servers
In another project based on a real-world scenario, I acted as a Cloud Specialist to show a team of on-premises DBAs how to provision a PostgreSQL database on Microsoft Azure.
I supported the deployment and showed the step-by-step to create the database service in Microsoft Azure. I shared how the connection to the database service in Azure worked, what were the steps of creating a new database, a new schema, and a new table. Also, I instructed them how to insert new records and query data in the table.
- Access to the PostgreSQL database service:
2. Database created:
To ensure database access from machines outside the Azure infrastructure, it is necessary to add a firewall rule that enables public access. For this, you need to know the public IP address of the machine that will be accessing the database.
If it’s your machine, you can find your public IP by accessing this website:
3. Adding a rule to the firewall for external access permission:
If it’s your machine, you can also rely on the IP detection performed by Azure.
Done! Only 3 steps are necessary to access a database running on Azure infrastructure from your local machine:
