PostgreSQL to Azure DB for PostgreSQL – Hyperscale (Citus) online migrations now generally available

by | Jan 27, 2021 | Technology | 0 comments

This article is contributed. See the original author and article here.

 


We are pleased to announce general availability of Azure Database Migration Service support for online (minimal downtime) migrations of PostgreSQL to Azure Database for PostgreSQL – Hyperscale (Citus). Azure Database Migration Service provides a single service that customers can use to migrate data from different database engines to Azure, all with built-in resiliency and robustness.


 


With online migrations, businesses can migrate their databases to Azure while the databases continue to be operational. This means that migrations can be completed with minimum downtime for critical applications, limiting the impact to service level availability and inconvenience their end customers.


Additional updates to the PostgreSQL to Azure Database for PostgreSQL migration scenario with this release include support for:



  • All PostgreSQL versions from 9.4 through 11.

  • Migrating to a higher version of PostgreSQL; there is no longer a requirement that minor versions of PostgreSQL match on the source and target.

  • Migrating from an AWS RDS Aurora Postgres version 10.6 or later database.

  • The BSON and ENUM data types.


We’ve also removed the:



  • Superuser privilege requirement; now, only the replication privilege is required.

  • Password string limitation regarding use of curly braces.


For more information about using Azure Database Migration Service to migrate data to Azure Database for PostgreSQL, see the following tutorials:



Azure Database for PostgreSQL – Hyperscale (Citus)


Azure Database for PostgreSQL – Hyperscale (Citus) transforms your Postgres database into a database that can scale up and down as well as scale out horizontally. Powered by the Citus extension, the service provides you with all the native capabilities of Postgres, including rich JSON support, powerful indexing, an array of datatypes, full text search, geospatial support, and much more. Because Citus is an extension to Postgres and doesn’t fork from the main project, you can stay current with your Postgres versions without worry about your infrastructure gradually fading into legacy mode.


For more information about Azure Database for PostgreSQL – Hyperscale (Citus), see the related service documentation.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Submit a Comment