Azure Database for PostgreSQL now supports asynchronous replication of data from one Azure Database for PostgreSQL server (the ‘master’) to up to five Azure Database for PostgreSQL servers (the ‘replicas’) in the same region. This allows read-heavy workloads to scale out and be balanced across replica servers according to users' preferences.
Azure Data Studio, our cross-platform data editor, now provides preview support for PostgreSQL. In addition, a Microsoft extension for PostgreSQL in Visual Studio Code is now also in preview. With these two releases, connect and modify your PostgreSQL databases, use IntelliSense and keyword completion to write queries, and browse database objects in a familiar object browsing experience. Use this new tooling with any PostgreSQL server hosted on-premises, on VMs, on managed Postgres in other clouds, and on Azure Database for PostgreSQL.
Microsoft has established a partnership with Timescale that introduces support for TimescaleDB in Azure Database for PostgreSQL. With the TimescaleDB extension, you can continue to use PostgreSQL while using TimescaleDB to scale for time-series workloads. Enabling the TimescaleDB extension on your new or existing Azure Database for PostgreSQL server will eliminate the need to run two databases to collect their relational and time-series data.
Azure Database for PostgreSQL users can now take advantage of the Hasura GraphQL Engine, a lightweight, high performance, open source product that instantly provides a real time GraphQL API on a Postgres database. With the GraphQL engine’s admin UI, users can explore their GraphQL APIs and manage their database schemas and data. In addition, the GraphQL engine also allows users to write custom resolvers with schema-stitching and to integrate serverless functions or microservice APIs that get triggered on database events.
Microsoft’s open source database services, Azure Database for MySQL and Azure Database for PostgreSQL, now provide users with the ability to scale up compute to 64 vCores in the general purpose pricing tiers and to 32 vCores in the memory optimized tiers. With the general availability release of this increase in compute, Azure Database for MySQL and Azure Database for PostgreSQL can support even larger workloads, helping you to better accommodate future growth.
Azure Database for PostgreSQL now supports asynchronous replication of data from one Azure Database for PostgreSQL server (the ‘master’) to up to five Azure Database for PostgreSQL servers (the ‘replicas’) in the same region. This allows read-heavy workloads to scale out and be balanced across replica servers according to your preferences. Replica servers are read-only; any writes are those replicated from data changes on the master. Stopping replication to a replica server causes it to become a standalone server that accepts reads and writes.
Access generally available functionality in the Azure Database Migration Service to migrate Amazon RDS for PostgreSQL to Azure Database for PostgreSQL while the source database remains online during migration.
You can now replicate data from a single Azure Database for PostgreSQL server (master) to up to five read-only servers (read replicas) within the same Azure region. This feature uses PostgreSQL's native asynchronous replication.