When we try to create a VM in azure , we get several options for PostgreSQL. I wanted to know if the azure VM on Postgre in below screenshot are managed .i.e . OS updates are taken care by Azure etc.

Hi @MS Techie - The answer is basically yes to officially supported distros that are published to the Azure Marketplace. It is a requirement that the 3rd party provide fixes and updates: Image Update Cadence Please also see supported distributions and versions ( link ). If the image was brought to Azure as a VM image, that would not be subject to automatic updates. These are the instructions for Azure Marketplace PostgreSQL image: Install and configure PostgreSQL on Azure Please let me know what else I can provide you. Regards, Mike

PostgreSQL images on Azure VM (Please see screenshot below) -- Are they managed like azure does OS updates etc for them ?

Accepted answer

Mike Ubezzi 2,776 Reputation points

2020-09-23T06:13:50.437+00:00

Hi @MS Techie - The answer is basically yes to officially supported distros that are published to the Azure Marketplace. It is a requirement that the 3rd party provide fixes and updates: Image Update Cadence

Please also see supported distributions and versions (link). If the image was brought to Azure as a VM image, that would not be subject to automatic updates. These are the instructions for Azure Marketplace PostgreSQL image: Install and configure PostgreSQL on Azure

Please let me know what else I can provide you.

Regards,
Mike
Please sign in to rate this answer.
MS Techie 2,686 Reputation points

2020-09-23T11:04:42.477+00:00

Thank you @Mike-Ubezzi-MSFT for your reply.

So in the screenshot i gave earlier , we see that most publishers are Postgres Professional .

So i assume that if one creates an Azure VM with this image , will it be Azure's responsibility to do OS updates or will it be the responsibility of Postgres Professional to do updates ?
or
is it just an Image with specific version of Postgres , where in OS updates should be done by the user and not the Publisher of the image , which in this example is Postgres Professional .?

Please guide.

Mike Ubezzi 2,776 Reputation points

2020-09-24T00:35:43.29+00:00

The OS updates are in fact provided by Azure for the initial SKU that was initially deployed and until that SKU reaches end-of-support, etc. The PostgreSQL Server images are provided to Azure Marketplace by the vendor in agreement with Azure Marketplace and the customer must manually (or programmatically) deploy updated PostgreSQL images that may include major or minor releases.

I hope this answers your specific question. Regards, Mike

MS Techie 2,686 Reputation points

2020-09-25T13:48:36.61+00:00

Thank you @Mike-Ubezzi-MSFT for your reply.

So if there is any image given by vendor like Postgres Professional , the image will be regularly updated by the vendor , so that we always have the latest , when we choose the image for next time.

My question was will the VM also be manged by them ... but then i gave it a thought and realized , if VM is also managed with azure taking care of OS updates etc, then it would be a PaaS option , not IaaS option.

So if i have install azure VM with Postgres version 12 and after 3 to 4 months , if postgres releases version 13 of database , then i will automatically get a pop-up in my azure VM , to upgrade to the latest version of postgres . I think you are referring about this point.

Mike Ubezzi 2,776 Reputation points

2020-09-25T21:55:32.287+00:00

Correct, @McTechie . If you were to deploy a bundled OS + PostgreSQL Server image, both OS and Server updates are provided by the vendor. In the scenario you presented, the OS updates are managed by Azure and the PostgreSQL updates are provided by the vendor. With regard to Azure managed updates, the following blog post is helpful: Managing updates for your Azure VM
Sign in to comment

Share via

PostgreSQL images on Azure VM (Please see screenshot below) -- Are they managed like azure does OS updates etc for them ?

0 additional answers