Add support for Azure Postgres Applicaton Service

Customers are increasingly using off-premisis Azure to host RPD servers for both Windows and Linux. With RPD 3.12 introducing PostgresSQL as the main database component, we have a great opportunity to enhance our offering by supporting Postgres application services rather than running a Postgres database either in Docker or natively with the RPD server. Here are some detals about PAS from one of our bigger customers:

We are looking at Azure Database for PostgresSQL, Flexible Server. It provides the database as a service and the underlying infrastructure is maintained by the cloud service provider. This provides high availability, backup, tuning etc as part of the service.

Have a look at: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview

you can see the architecture about half way down the page (file attatched). This shows a highly available instance, the primary database server replicates the data synchronously to a second standby server in a different availability zone – usually a second Data Center on the same campus as opposed to a second Data Center in a different region.

An application like RPD will be given a URI to connect to. The Postgres Linux VMs, the storage and the backups are all taken care of by Microsoft. The application sees the database as normal, just like a native Postgres database.