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

Published 01-29-2021 10:16 AM 3,158 Views
Microsoft

 

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. For more information about Azure Database for PostgreSQL – Hyperscale (Citus), see the related service documentation.

2 Comments
Senior Member

When will PostgreSQL 12 be available on single server and in citus  ??

Microsoft

@karthi natarajan, please contact the Ask Azure DB for PostgreSQL alias directly for a response to your question. Thanks!

%3CLINGO-SUB%20id%3D%22lingo-sub-1191820%22%20slang%3D%22en-US%22%3EPostgreSQL%20to%20Azure%20DB%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus)%20online%20migrations%20now%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191820%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20pleased%20to%20announce%20general%20availability%20of%20%3CA%20href%3D%22hhttps%3A%2F%2Fazure.microsoft.com%2Fservices%2Fdatabase-migration%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20Database%20Migration%20Service%3C%2FA%3E%20support%20for%20online%20(minimal%20downtime)%20migrations%20of%20PostgreSQL%20to%20Azure%20Database%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus).%20Azure%20Database%20Migration%20Service%20provides%20a%20single%20service%20that%20customers%20can%20use%20to%20migrate%20data%20from%20different%20database%20engines%20to%20Azure%2C%20all%20with%20built-in%20resiliency%20and%20robustness.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20online%20migrations%2C%20businesses%20can%20migrate%20their%20databases%20to%20Azure%20while%20the%20databases%20continue%20to%20be%20operational.%20This%20means%20that%20migrations%20can%20be%20completed%20with%20minimum%20downtime%20for%20critical%20applications%2C%20limiting%20the%20impact%20to%20service%20level%20availability%20and%20inconvenience%20their%20end%20customers.%3C%2FP%3E%0A%3CP%3EAdditional%20updates%20to%20the%20PostgreSQL%20to%20Azure%20Database%20for%20PostgreSQL%20migration%20scenario%20with%20this%20release%20include%20support%20for%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAll%20PostgreSQL%20versions%20from%209.4%20through%2011.%3C%2FLI%3E%0A%3CLI%3EMigrating%20to%20a%20higher%20version%20of%20PostgreSQL%3B%20there%20is%20no%20longer%20a%20requirement%20that%20minor%20versions%20of%20PostgreSQL%20match%20on%20the%20source%20and%20target.%3C%2FLI%3E%0A%3CLI%3EMigrating%20from%20an%20AWS%20RDS%20Aurora%20Postgres%20version%2010.6%20or%20later%20database.%3C%2FLI%3E%0A%3CLI%3EThe%20BSON%20and%20ENUM%20data%20types.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EWe%E2%80%99ve%20also%20removed%20the%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESuperuser%20privilege%20requirement%3B%20now%2C%20only%20the%20replication%20privilege%20is%20required.%3C%2FLI%3E%0A%3CLI%3EPassword%20string%20limitation%20regarding%20use%20of%20curly%20braces.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EFor%20more%20information%20about%20using%20Azure%20Database%20Migration%20Service%20to%20migrate%20data%20to%20Azure%20Database%20for%20PostgreSQL%2C%20see%20the%20following%20tutorials%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdms%2Ftutorial-postgresql-azure-postgresql-online-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMigrate%20PostgreSQL%20to%20Azure%20DB%20for%20PostgreSQL%20online%20using%20DMS%20via%20the%20Azure%20portal%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdms%2Ftutorial-postgresql-azure-postgresql-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMigrate%20PostgreSQL%20to%20Azure%20DB%20for%20PostgreSQL%20online%20using%20DMS%20via%20the%20Azure%20CLI%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3EAzure%20Database%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EAzure%20Database%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus)%20transforms%20your%20Postgres%20database%20into%20a%20database%20that%20can%20scale%20up%20and%20down%20as%20well%20as%20scale%20out%20horizontally.%20Powered%20by%20the%20Citus%20extension%2C%20the%20service%20provides%20you%20with%20all%20the%20native%20capabilities%20of%20Postgres%2C%20including%20rich%20JSON%20support%2C%20powerful%20indexing%2C%20an%20array%20of%20datatypes%2C%20full%20text%20search%2C%20geospatial%20support%2C%20and%20much%20more.%20Because%20Citus%20is%20an%20extension%20to%20Postgres%20and%20doesn't%20fork%20from%20the%20main%20project%2C%20you%20can%20stay%20current%20with%20your%20Postgres%20versions%20without%20worry%20about%20your%20infrastructure%20gradually%20fading%20into%20legacy%20mode.%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20about%20Azure%20Database%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus)%2C%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fpostgresql%2Foverview%23azure-database-for-postgresql---hyperscale-citus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Erelated%20service%20documentation%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1191820%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20pleased%20to%20announce%20general%20availability%20of%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fservices%2Fdatabase-migration%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Database%20Migration%20Service%3C%2FA%3E%20support%20for%20online%20(minimal%20downtime)%20migrations%20of%20PostgreSQL%20to%20Azure%20Database%20for%20PostgreSQL%20%E2%80%93%20Hyperscale%20(Citus).%20Azure%20Database%20Migration%20Service%20provides%20a%20single%20service%20that%20customers%20can%20use%20to%20migrate%20data%20from%20different%20database%20engines%20to%20Azure%2C%20all%20with%20built-in%20resiliency%20and%20robustness.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Jan 29 2021 10:18 AM
Updated by: