Managing Migration with Server Parameters

APPLIES TO: Azure Database for PostgreSQL flexible server

To provide customers with greater control over migration settings, we have introduced configurable migration parameters within the server parameters section. These parameters allow users to tailor their migration experience based on their data requirements, reducing the need for backend interventions and support requests.

For example, customers can use the azure.migration_skip_role_user parameter to decide whether user roles should be migrated automatically or handled manually. Similarly, parameters such as azure.migration_table_split_size allow users to optimize data transfer efficiency. These options empower customers to manage their migration settings independently, improve flexibility, and reduce operational overhead.

Screenshot of Migration server parameters within Azure Database for PostgreSQL flexible server.

Migration server parameters

Parameter Name Type Description Supported Sources
azure.migration_skip_role_user Boolean When set to on, this parameter excludes user roles from the migration process. only Azure Database for PostgreSQL - Single server
azure.migration_copy_with_binary Boolean When set to on, this parameter enables the use of the binary format for copying data during migration. All supported sources by the migration service
azure.migration_table_split_size Integer (MB) Defines the size (in MB) at which tables will be partitioned during migration. All supported sources by the migration service
azure.migration_skip_analyze Boolean When set to on, this parameter skips the analyze phase during the migration. only Azure Database for PostgreSQL - Single server
azure.migration_skip_large_objects Boolean When set to on, this parameter skips the migration of large objects such as BLOBs. All supported sources by the migration service
azure.migration_skip_extensions Boolean When set to on, this parameter skips the migration of extensions. All supported sources by the migration service

Note

  • The migration configurable server parameters are only applicable to the new Azure Database for PostgreSQL flexible server.
  • Changes in the migration configurable server parameters do not require a restart.
  • The azure.migration_skip_role_user parameter is disabled for the target Azure Database for PostgreSQL flexible server version 16.

These parameters allow users to customize their migration process efficiently, ensuring a streamlined and optimized experience while minimizing dependencies on backend adjustments.