{"id":7548,"date":"2024-09-02T18:55:41","date_gmt":"2024-09-02T15:55:41","guid":{"rendered":"https:\/\/mummila.net\/kommentit\/?p=7548"},"modified":"2024-09-02T18:55:41","modified_gmt":"2024-09-02T15:55:41","slug":"i-was-able-to-work-around-this-by-temporarily-installing-postgresql-14-from-the-pgdg-repository","status":"publish","type":"post","link":"https:\/\/mummila.net\/kommentit\/2024\/09\/02\/i-was-able-to-work-around-this-by-temporarily-installing-postgresql-14-from-the-pgdg-repository\/","title":{"rendered":"I was able to work around this by temporarily installing postgresql-14 from the PGDG repository"},"content":{"rendered":"<p>I was able to work around this (in a test VM, after upgrading it from 20.04 to 24.04) with adapted instructions from a blogpost [1], by temporarily installing postgresql-14 from the PGDG repository for doing the 14 -&gt; 16 upgrade:<\/p>\n<p># apt install postgresql-common<br \/>\n# \/usr\/share\/postgresql-common\/pgdg\/apt.postgresql.org.sh<br \/>\n# apt install postgresql-14<br \/>\n# pg_dropcluster 16 main &#8211;stop<br \/>\n# pg_upgradecluster 14 main<br \/>\n# pg_dropcluster 14 main<br \/>\n# apt purge postgresql-14 postgresql-client-14<br \/>\n# rm \/etc\/apt\/sources.list.d\/pgdg.sources<br \/>\n# apt update<\/p>\n<p>I have yet to try this on my actual server with actual data. Please be careful if you attempt this with a production database.<\/p>\n<p>*[1] https:\/\/www.directedignorance.com\/blog\/upgrading-postgresql-14-to-16-on-ubuntu<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8230;\/pgdg\/apt.postgresql.org.sh &amp;&amp; apt install postgresql-14 &amp;&amp; pg_dropcluster 16 main &#8211;stop &amp;&amp; pg_upgradecluster 14 main &amp;&amp; pg_dropcluster 14 main<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8860],"tags":[22990,22989,2679],"class_list":["post-7548","post","type-post","status-publish","format-standard","hentry","category-vianhallintajarjestelmat","tag-pgdg","tag-postgresql","tag-ubuntu","sijainti-launchpad"],"_links":{"self":[{"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/posts\/7548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/comments?post=7548"}],"version-history":[{"count":1,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/posts\/7548\/revisions"}],"predecessor-version":[{"id":7550,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/posts\/7548\/revisions\/7550"}],"wp:attachment":[{"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/media?parent=7548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/categories?post=7548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mummila.net\/kommentit\/wp-json\/wp\/v2\/tags?post=7548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}