<  Back to rules search

Azure PostgreSQL Database Server uses the current major PostgreSQL version

azure.dbforpostgresql

Set up the azure.dbforpostgresql integration.

Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.

Description

PostgreSQL is using the most recent major version available.

Rationale

PostegreSQL employs both minor and major version updates. Using the most recent version available (particularly the most recent major version) ensures that you are using the most secure, feature rich, and supported version available. Azure Database Migration Service can help minimize downtime when performing version upgrades in Azure Database for PostgreSQL - Single Server.

Remediation

From the console

  1. Use Azure’s Configure server parameters in Azure Database for PostgreSQL - Single Server via the Azure portal to configure a target database with desired PostgreSQL version, network settings, and parameters.
  2. Follow the steps listed at Tutorial: Migrate/Upgrade Azure DB for PostgreSQL - Single Server to Azure DB for PostgreSQL - Single Server online using DMS via the Azure portal to migrate the old database to the new database.

From the command line

  1. Use Azure’s Customize server configuration parameters for Azure Database for PostgreSQL - Single Server using Azure CLI to configure a target database with desired PostgreSQL version, network settings, and parameters.
  2. Follow the steps listed at Tutorial: Migrate PostgreSQL to Azure DB for PostgreSQL online using DMS via the Azure CLI to migrate the old database to the new database.