Altinn / altinn-platform

Altinn Platform infrastructure
7 stars 1 forks source link

Upgrade PostgreSQL database for Auditlog to 16 #984

Open ootneim opened 1 month ago

ootneim commented 1 month ago

Upgrade the PostgreSQL database server to version 16 after data has been migrated from using Timescale.

Upgrade procedures

  1. Delete timescale tables
  2. Run 'DROP EXTENSION IF EXISTS timescaledb CASCADE;'
  3. Remove Timescaledb azure.extensions
  4. Remove Timescaledb shared_preload_libraries
  5. Make sure server have atlest 2vCores
  6. Upgrade PostgreSQL to Version 16

Upgrade performed in: