Table of Contents

Connaître l'avancement d'un auto-vaccum

SELECT
    pid,
    relid::regclass AS table_name,
    phase,
    heap_blks_total,
    heap_blks_scanned,
    heap_blks_scanned * 100 / heap_blks_total::float AS percent_complete,
    index_vacuum_count,
    max_dead_tuples,
    num_dead_tuples
FROM
    pg_stat_progress_vacuum;

 Mise à jour du serveur postgresql de la version 11 à la version 16

 Procédure

apt list --installed | grep postg
pg_dropcluster 16 main --stop
pg_upgradecluster 11 main
service postgresql@11-main stop
service postgresql@16-main start
pg_lsclusters
pg_dropcluster 11 main
apt-get purge postgresql-11 postgresql-client-11

 Bibliographie

https://karloluiten.nl/upgrade-postgresql-cluster-from-13-to-15/