Étape 1 : Préparation
- Fermer toutes les applications utilisant Postgresql : odoo, dovecot, gitlab, …
- Stopper le service Postgresql :
systemctl stop postgresql
Étape2 : Mettre à jour
1
2
3
4
5
| # pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.4 main 5432 down postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
9.6 main 5433 down postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log |
# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.4 main 5432 down postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
9.6 main 5433 down postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
On supprime d’abord le cluster crée lors de la mise à jour
1
2
| # pg_dropcluster 9.6 main --stop
Redirecting stop request to systemctl |
# pg_dropcluster 9.6 main --stop
Redirecting stop request to systemctl
On met à jour le cluster 9.4 en 9.6 :
1
2
3
4
5
6
7
8
| # pg_upgradecluster 9.4 main
Stopping old cluster...
[...]
Success. Please check that the upgraded cluster works. If it does,
you can remove the old cluster with
pg_dropcluster 9.4 main |
# pg_upgradecluster 9.4 main
Stopping old cluster...
[...]
Success. Please check that the upgraded cluster works. If it does,
you can remove the old cluster with
pg_dropcluster 9.4 main
Étape 3 : Nettoyage
La liste des clusters devrait ensuite ressemble à cela :
1
2
3
4
5
| # pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.4 main 5433 down postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
9.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log |
# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.4 main 5433 down postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
9.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
une fois tout d’aplomb, on peut supprimer l’ancien cluster (le 9.4)
1
2
3
4
| # pg_dropcluster 9.4 main
# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log |
# pg_dropcluster 9.4 main
# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
Au finale on supprimer totalement l’ancienne version (9.4)
1
| # apt-get --purge remove postgresql-9.4 postgresql-client-9.4 |
# apt-get --purge remove postgresql-9.4 postgresql-client-9.4
