Microsoft Azure Database for PostgreSQL

Azure Database for PostgreSQL offers Flexible Server, which provides configurable compute, storage, and maintenance-window control, as well as a Burstable tier suited for smaller workloads. Both are fully managed by Microsoft, handling patching, backups, and high availability automatically.

Yes, Azure Database for PostgreSQL Flexible Server supports the pgvector extension, enabling storage and similarity search of vector embeddings directly within the database. This allows developers to build retrieval-augmented generation and semantic-search applications without a separate vector store.

Microsoft provides the Azure Database Migration Service as well as standard pg_dump and pg_restore toolchains for moving existing PostgreSQL databases to Azure. Flexible Server is the recommended target for most new migrations because it offers broader version compatibility and configuration flexibility.

Azure Database for PostgreSQL Flexible Server supports multiple major community PostgreSQL versions, with Microsoft adding new major versions within a few months of their upstream release. The legacy Single Server deployment option supports a narrower set of older versions and is being phased out in favor of Flexible Server.