What is our primary use case?
My main use case for Azure Database for PostgreSQL involves migration from on-premise to Azure Database for PostgreSQL using technologies such as a migration database DMA.
A specific example of a migration project I have worked on using Azure Database for PostgreSQL involves shipping all workloads from on-premise, locally inside the data center to Azure cloud using all structures and all reliability and security from cloud into Azure.
Regarding my use case and the types of workloads I have migrated, we need to ship first the schema, after moving each data access to Azure cloud. The ability to save all restore points in the backup point in time into Azure is very helpful with teams such as DevOps and DBA.
How has it helped my organization?
Azure Database for PostgreSQL has positively impacted my organization because it provides more CapEx and OpEx according to the type of the databases. When we needed to use on-premises data centers, the cost was very high. By moving to the cloud, we shifted costs from OpEx to CapEx.
Regarding the impact on costs after moving to Azure Database for PostgreSQL, we can spread each cost according to each client, and when we use a specific database, we can tag and monitor the cost of each resource to understand the budget, similar to on-premises.
Azure Database for PostgreSQL has facilitated the adoption of AI technologies in our database operations by allowing the use of tools such as GitOps, which provides greater flexibility for squads to utilize and promote resources in different environments.
Azure Database for PostgreSQL has influenced our application development process; using migration tools allows us to deploy in incremental flows, which results in tiny differences in resources while providing greater governance and replicability.
My organization's database uptime has changed after implementing Azure Database for PostgreSQL. I believe it has improved by approximately 90%, because during the deployment of on-premises PostgreSQL, we needed to stop the application for maintenance, but with Azure, we can restore at any time using point-in-time backups, which is very helpful for developers.
What is most valuable?
In my opinion, the best feature of Azure Database for PostgreSQL is the backup point in time, which is very helpful during migrations or any situation where we need to restore the database.
This backup feature has helped me in real-world scenarios due to scalability and elasticity in Azure cloud, which is very helpful when moving thousands of gigabytes in each database during the migration process.
When it comes to features of Azure Database for PostgreSQL, the integration with monitoring is very beneficial, such as accessing Azure Monitor, allowing us to check and receive alerts if there is any spike in usage. This is a very different approach compared to on-premises, but in Azure, it is very helpful due to its scalability and flexibility.
Concerning Azure Database for PostgreSQL's AI capabilities, its governance and security are much better because it is very helpful and does not require deep knowledge of queries or complex arithmetic, which is a beneficial feature.
My experience with the monitoring and management tools provided by Azure Database for PostgreSQL is positive; metrics can be sent from the cloud by another application such as DataDog, allowing for alerts and being very helpful in checking performance issues during incidents.
Regarding impressions of security features in Azure Database for PostgreSQL, the most valuable feature is the firewall security, which blocks any unauthorized access. I need to configure access for each developer by their IP address, which is critical for security.
What needs improvement?
In terms of improvement for Azure Database for PostgreSQL, the native applications can be enhanced, as we can use different tools to connect the database, but I believe the browser on the Azure portal can be made more user-friendly.
Regarding needed improvements, I find that the refresh time of the page being five minutes causes the same issues according to the types of scripts or queries when running. If the query takes too long to execute, I need to use a specific tool rather than the browser, which sometimes generates concerns for developers.
For how long have I used the solution?
I have been using Azure Database for PostgreSQL for approximately eight years.
What do I think about the stability of the solution?
Regarding accuracy and reliability of output, Azure Database for PostgreSQL has proven to be very helpful, as I have not experienced any issues such as lack of performance or instability.
I have not experienced any significant latency with Azure Database for PostgreSQL, as the performance can be improved based on the pricing tier of the database, and I have not encountered issues according to the status page in Azure.
Azure Database for PostgreSQL is stable.
What do I think about the scalability of the solution?
Azure Database for PostgreSQL's scalability is better; we can distribute resources according to the self-region and budget, while being mindful of how pricing tiers impact costs as scalability grows.
How are customer service and support?
Whenever I need customer support, I receive excellent assistance from the Azure support analysts.
On a scale of one to ten, I would rate customer support a ten.
Which solution did I use previously and why did I switch?
I previously used Azure MySQL server and Azure SQL server due to different approaches, but the logic behind them is similar to Azure Database for PostgreSQL.
What was our ROI?
I have seen a return on investment; specifically, I save money and time because in my recent project using Azure Database for PostgreSQL, I do not need a virtual machine in the data center. I can allocate all databases according to each client's usage of different resources, allowing cost savings by assigning costs to each client according to their requirements.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup cost, and licensing is that pricing is very important due to budget constraints in each project; while migration costs can be high during the process, after migration, savings can be substantial compared to on-premises applications.
Which other solutions did I evaluate?
Before choosing Azure Database for PostgreSQL, I evaluated other options, but the licensing differences are significant, and we found that PostgreSQL has much better cost advantages compared to solutions such as Oracle or SQL Server.
What other advice do I have?
I would rate Azure Database for PostgreSQL a nine out of ten.
I chose a nine because it is very helpful and easy to run some types of queries, but in some cases, I need specific tools installed locally, although it performs much better in comparison with on-premises use.
The integration of Azure Database for PostgreSQL with other Azure services has not impacted our overall cloud strategy, as we are not working with a multi-cloud strategy, but we can replicate with tools such as EAC for multiple applications while creating each structure in each cloud.
I would advise others looking into using Azure Database for PostgreSQL to pay attention to computing and storage, as they can improve the cost of resource allocation. Azure Database for PostgreSQL receives a rating of nine out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.