{"id":552,"date":"2025-11-16T10:46:02","date_gmt":"2025-11-16T09:46:02","guid":{"rendered":"https:\/\/kszyh.kisim.eu.org\/?p=552"},"modified":"2025-11-16T10:48:39","modified_gmt":"2025-11-16T09:48:39","slug":"update-postgres-working-in-docker-from-17-to-18","status":"publish","type":"post","link":"https:\/\/kszyh.kisim.eu.org\/?p=552","title":{"rendered":"Update PostgreSQL working in Docker from version 17 to version 18."},"content":{"rendered":"<pre class=\"lang:default decode:true\">sudo docker compose exec postgres pg_dumpall -U postgres &gt; backup17.sql\r\n\/\/ Edit docker compose \/ change data dir to empty\r\nsudo docker compose exec -T postgres sh -c \"psql -U postgres\" &lt; backup17.sql \r\n<\/pre>\n<p>Important: Postgres 18 changed data dir mount point:<\/p>\n<pre class=\"lang:default decode:true \">- \/mnt\/docker-data\/postgres17-data:\/var\/lib\/postgresql\/data\r\n- \/mnt\/docker-data\/postgres18-data:\/var\/lib\/postgresql<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sudo docker compose exec postgres pg_dumpall -U postgres &gt; backup17.sql \/\/ Edit docker compose \/ change data dir to empty sudo docker compose exec -T postgres sh -c &#8222;psql -U postgres&#8221; &lt; backup17.sql Important: Postgres 18 changed data dir mount point: &#8211; \/mnt\/docker-data\/postgres17-data:\/var\/lib\/postgresql\/data &#8211; \/mnt\/docker-data\/postgres18-data:\/var\/lib\/postgresql &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-552","post","type-post","status-publish","format-standard","hentry","category-bez-kategorii"],"_links":{"self":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=552"}],"version-history":[{"count":3,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/552\/revisions"}],"predecessor-version":[{"id":555,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/552\/revisions\/555"}],"wp:attachment":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}