Sur le nouveau serveur, installer postgresql en t\u00e9l\u00e9chargeant la cl\u00e9 du serveur ad hoc dans \/etc\/apt\/keyrings:<\/p>\n
# wget https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc<\/p><\/blockquote>\n\n
On ajoute ensuite un fichier pdpg.list dans \/etc\/apt\/sources.list.d avec ceci:<\/p>\n
deb [signed-by=\/etc\/apt\/keyrings\/AC-------.asc] https:\/\/apt.postgresql.org\/pub\/repos\/apt bookworm-pgdg main<\/p><\/blockquote>\n\n
On installe ensuite la version postgresql de l'ancien serveur :<\/p>\n
# apt update\n# apt install postgresql-15<\/p><\/blockquote>\n\n
On change le fichier \/etc\/postgresql\/15\/main\/postgresql.conf:<\/p>\n
listen_addresses = '*'<\/p><\/blockquote>\n\n
Et le fichier \/etc\/postgresql\/15\/main\/pg_hba.conf en ajoutant:<\/p>\n
host all all 127.0.0.1 md5 \nhost all all 192.168.0.1\/25 md5<\/p><\/blockquote>\n\n
On red\u00e9marre le service:<\/p>\n
# systemctl restart postgresql<\/p><\/blockquote><\/blockquote>\n\n
On se connecte avec le compte postgres:<\/p>\n
# su postgres<\/p><\/blockquote>\n\n
On t\u00e9l\u00e9charge le dump fait au pr\u00e9alable avec pg_dumpall > fichier.dmp et on r\u00e9tablit la base:<\/p>\n
$ psql < fichier.dmp\n$ exit<\/p><\/blockquote>\n\n
On installe ensuite le nouveau cluster :<\/p>\n
# apt install postgresql-16<\/p><\/blockquote>\n\n
Pour lister les cluster :<\/p>\n
# pg_lsclusters<\/p><\/blockquote>\n\n
On supprime la nouvelle version du cluster:<\/p>\n
# pg_dropcluster 16 main --stop<\/p><\/blockquote>\n\n
On upgrade la version pr\u00e9c\u00e9dente:<\/p>\n
# pg_upgradecluster 15 main<\/p><\/blockquote>\n\n
Le nouveau cluster est en vert, on peut supprimer l'ancien:<\/p>\n
# pg_dropcluster 15 main<\/p><\/blockquote>\n\n
Et on d\u00e9sintalle l'ancienne version :<\/p>\n
# apt purge postgresql-15 postgresql-client-15<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
Sur le nouveau serveur, installer postgresql en t\u00e9l\u00e9chargeant la cl\u00e9 du serveur ad hoc dans \/etc\/apt\/keyrings: # wget https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc On ajoute ensuite un fichier pdpg.list dans \/etc\/apt\/sources.list.d avec ceci: deb [signed-by=\/etc\/apt\/keyrings\/AC-------.asc] https:\/\/apt.postgresql.org\/pub\/repos\/apt bookworm-pgdg main On installe ensuite la version postgresql de l'ancien serveur : # apt update # apt install postgresql-15 On change le fichier […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[148],"tags":[188,25],"class_list":["post-754","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-migration","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=754"}],"version-history":[{"count":1,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/754\/revisions"}],"predecessor-version":[{"id":755,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/754\/revisions\/755"}],"wp:attachment":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}