Azure #17 - Azure Database for PostgreSQL | Azure Tutorial

Azure Database for PostgreSQL is a managed Postgres database service that Azure offers. Azure handles the majority of the configuration, provides you a connection string to connect to the database and allows easy backups and restores.

In this tutorial we'll discuss some of the benefits to using the managed service rather than doing all the database configuration yourself, pricing, sizing, server parameters, single server and hyperscale (citrus). We'll create a single server, set up firewall rules, create a read replicate and verify we can psql into our postgres database.

Overview:

Pricing:

[НиколайБеляшов-вк]

Great job! Thank you! You really help me to undestand!

[MrAdhito]

Thanks for uploading !!, This video helped me setting up my Azure PostgreSQL

[mayurdhande]

Thanks for the video Will. This was really helpful.

[satyendrapratapsingh]

Excellent explaining methodology. Thanks, its very useful

[atom]

i am using psycopg2 with Azure postgresql. Looks like every query takes about 0.4 seconds. Can you give an advice on how i can improve it? The same query takes 0.010 milliseconds on the postgres terminal.

[Osama-qslr]

Great video, Will! I have a quick, but perhaps a bit stupid question: I want to create a database through Azure that can be shared and made accessible to two others. And for instance connect to Dbeaver. How should I approach this? Could I do exactly what you did here? Many thanks!

[ledeveloperstack]

I tried to connect to the postgres shell again with the same script, but I got an error on my console
psql: error: FATAL: no pg_hba.conf entry for host "***.****.**:*"

[sushenvashikar]

Good Job Will. I have a question, adding a VNET rule is not enabled in connection security option in my case. Can you tell me why? I googled it but didn't get a satisfying answer.

[rajpes]

Sir, Can we connect source as on-premise postgresql database and then do mapping data flow transformations in Azure data factory. Once done send the transformed data back onto On-premise Postgresql database. If yes can you please guide me with this issue I am facing.Thanks!

[TK-cuyo]

Thanks for the video!!
But how can we make it highly available?

[vinod-ijdz]

Is it possible to create new server from backup from different subscription ?

[shymonr]

i am getting policy voilation while creating postgres

[nikhilbogadi]

How to stop azure database for postgresql