Date: Sat, 22 Feb 2025 20:19:50 +0100
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Alexander Farber <alexander.farber@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Azure Database for PostgreSQL flexible server vs other Azure
 offerings
Message-ID: <Z7ojVhicaKRF7VMR@elch.exwg.net>
References: <CAADeyWiRpyaqUMP5sJR971fUj65WX1CEjHVmg12KvsgUe7vFsg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <CAADeyWiRpyaqUMP5sJR971fUj65WX1CEjHVmg12KvsgUe7vFsg@mail.gmail.com>
User-Agent: Mutt/2.2.13 (2024-03-09)
Archived-At: <https://www.postgresql.org/message-id/Z7ojVhicaKRF7VMR%40elch.exwg.net>
Precedence: bulk

## Alexander Farber (alexander.farber@gmail.com):

> - https://azure.microsoft.com/en-us/products/postgresql "Azure Database for
> PostgreSQL" - this one scares me be talking about AI that we do not need.
> Also it looks more like some abstract product or is it a real setup?

That's the top level overview, and as it's 2025 all the high-level,
glossy material has to mention AI.

> - "Azure Database for PostgreSQL Single Server" - I would take that, but it
> is obsolete/deprecated?

"Is being retired in March 2025" - best to be ignored now, it's basically
gone.

> - "Azure Database for PostgreSQL Flexible Server" - Looks like I have to
> take this one, but I do not want all the replication/zones features,
> because I have no experience there and we already have had enough headache
> with Redis Enterprise and some hashes not being saved because they are on
> different shards etc.

HA with PostgreSQL is not that much of an headache (unless you invest
extra effort and code, the "normal" replication is really just
replication).
Anyways, HA is optional with the Flexible Server, as I read the
quickstart guide:
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/quickstart-create-server
(See table under item 8).

> So my question is: who is using what for PostgreSQL on Azure and how
> happy/unhappy are you with your product?

"Single Server" sure was a source of unhappiness :)

REegards,
Christoph

-- 
Spare Space