{"id":48,"date":"2019-01-25T13:02:15","date_gmt":"2019-01-25T12:02:15","guid":{"rendered":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/?p=48"},"modified":"2021-02-05T12:31:43","modified_gmt":"2021-02-05T11:31:43","slug":"postgresql-de-94-a-96-suite-a-un-upgrade-de-debia","status":"publish","type":"post","link":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/postgresql-de-94-a-96-suite-a-un-upgrade-de-debia\/","title":{"rendered":"postgresql &#8211; de 9.4 \u00e0 9.6 suite \u00e0 un upgrade de debian jessie vers stretch"},"content":{"rendered":"<p>Suite \u00e0 la mise \u00e0 jour de WAPT 1.3 vers 1.6 sous Debian jessie et ensuite \u00e0 un full-upgrade vers Debian stretch, vous allez vous retrouver en pr\u00e9sence de deux instances PostgreSQL (ou 2 clusters). Voici la proc\u00e9dure pour migrer de PostgreSQL 9.4 vers 9.6.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-content\/uploads\/sites\/2\/2019\/01\/15484191719655.jpg\" alt=\"\" \/><\/p>\n<p><!--more--><\/p>\n<h1>Pr\u00e9-requis avant migration<\/h1>\n<ul>\n<li>Fermer l&rsquo;ensemble des applications utilisant le service PostgreSQL : WAPT, &#8230;<\/li>\n<li>Stopper le service PostgreSQL : <\/li>\n<\/ul>\n<pre><code># systemctl stop waptserver\n# systemctl stop postgresql\n<\/code><\/pre>\n<h1>Mise \u00e0 jour du moteur PostgreSQL 9.4 vers 9.6<\/h1>\n<p>Lister les cluster disponible sur la machine :<\/p>\n<pre><code># pg_lsclusters\nVer Cluster Port Status Owner Data directory Log file\n9.4 main 5432 down postgres \/var\/lib\/postgresql\/9.4\/main \/var\/log\/postgresql\/postgresql-9.4-main.log\n9.6 main 5433 down postgres \/var\/lib\/postgresql\/9.6\/main \/var\/log\/postgresql\/postgresql-9.6-main.log\n<\/code><\/pre>\n<p>Dans un premier temps, nous supprimons le cluster pr\u00e9alablement cr\u00e9\u00e9 lors de la mise \u00e0 jour vers debian stretch<\/p>\n<pre><code># pg_dropcluster 9.6 main --stop\nRedirecting stop request to systemctl\n<\/code><\/pre>\n<p>Ensuite nous proc\u00e9dons \u00e0 la mise \u00e0 jour du cluster 9.4 en 9.6 :<\/p>\n<pre><code># pg_upgradecluster 9.4 main\nStopping old cluster...\n[...]\nSuccess. Please check that the upgraded cluster works. If it does,\nyou can remove the old cluster with\n<\/code><\/pre>\n<h1>Nettoyage du moteur PostgreSQL 9.4<\/h1>\n<p>Pr\u00e9c\u00e9demment nous avons migr\u00e9 les bases du moteur 9.4 vers 9.6. Avec la commande suivant nous confirmons l&rsquo;arr\u00eat du moteur 9.4 et nous pouvons proc\u00e9der \u00e0 sa suppression.<\/p>\n<pre><code># pg_lsclusters\nVer Cluster Port Status Owner Data directory Log file\n9.4 main 5433 down postgres \/var\/lib\/postgresql\/9.4\/main \/var\/log\/postgresql\/postgresql-9.4-main.log\n9.6 main 5432 online postgres \/var\/lib\/postgresql\/9.6\/main \/var\/log\/postgresql\/postgresql-9.6-main.log\n<\/code><\/pre>\n<p>Suppression du cluster 9.4 :<\/p>\n<pre><code># pg_dropcluster 9.4 main\n<\/code><\/pre>\n<p>V\u00e9rification de la suppression :<\/p>\n<pre><code># pg_lsclusters\nVer Cluster Port Status Owner Data directory Log file\n9.6 main 5432 online postgres \/var\/lib\/postgresql\/9.6\/main \/var\/log\/postgresql\/postgresql-9.6-main.log\n<\/code><\/pre>\n<p>Apr\u00e8s v\u00e9rification il est possible de supprimer totalement l\u2019ancienne version de PostgreSQL 9.4 :<\/p>\n<pre><code># apt-get remove --purge libssl1.0.0 libxapian22 postgresql-9.4 postgresql-client-9.4 postgresql-contrib-9.4 \n<\/code><\/pre>\n<h1>D\u00e9sactiver IPV6 pour PostgreSQL<\/h1>\n<p>Depuis le r\u00e9pertoire <em>\/etc\/postgresql\/9.6\/main\/<\/em> :<\/p>\n<pre><code># cd \/etc\/postgresql\/9.6\/main\/\n<\/code><\/pre>\n<p>Ajouter la ligne suivant au fichier <em>postgresql.conf<\/em><\/p>\n<pre><code># vi \/etc\/postgresql\/9.6\/main\/postgresql.conf\nlisten_addresses = '127.0.0.1'\n<\/code><\/pre>\n<p>Commenter la ligne 94 du fichier <em>pg_hba.conf<\/em><\/p>\n<pre><code># vi \/etc\/postgresql\/9.6\/main\/pg_hba.conf\n# IPv6 local connections:\n#host    all             all             ::1\/128                 md5\n<\/code><\/pre>\n<p>Relancer PostgreSQL et v\u00e9rifier la bonne prise en compte des modifications:<\/p>\n<pre><code># netstat -ntl | grep 5432\ntcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Suite \u00e0 la mise \u00e0 jour de WAPT 1.3 vers 1.6 sous Debian jessie et ensuite \u00e0 un full-upgrade vers Debian stretch, vous allez vous retrouver en pr\u00e9sence de deux instances PostgreSQL (ou 2 clusters). Voici la proc\u00e9dure pour migrer de PostgreSQL 9.4 vers 9.6.<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[19,11],"tags":[20,22,2,21,23],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-bdd","category-linux","tag-debian","tag-jessie","tag-linux","tag-postgresql","tag-stretch"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBEVZ-M","jetpack_likes_enabled":false,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":12,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":71,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/posts\/48\/revisions\/71"}],"wp:attachment":[{"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/homepages.lcc-toulouse.fr\/colombet\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}