{"id":4473,"date":"2015-01-21T20:42:19","date_gmt":"2015-01-21T12:42:19","guid":{"rendered":"https:\/\/lttt.blog.ustc.edu.cn\/?p=4473"},"modified":"2015-01-21T20:42:19","modified_gmt":"2015-01-21T12:42:19","slug":"upgrade-postgresql-9-3-on-debian-7-wheezy","status":"publish","type":"post","link":"https:\/\/lttt.vanabel.cn\/?p=4473","title":{"rendered":"Upgrade PostgreSQL 9.3 on Debian 7 Wheezy"},"content":{"rendered":"<h3>Setup current Debian version<\/h3>\n<p>Version 9.1 is the current PostgreSQL version in Debian Wheezy (the time of writing this article). Installation is simple:<br \/>\n<code>apt-get install postgresql<\/code><\/p>\n<h3>Setup latest PostgreSQL version on Debian<\/h3>\n<ol>\n<\/ol>\n<ol>\n<li>Add the PostgreSQL Apt Repositorycreate a Debian sources list file (e.g. pgdg.list)<br \/>\n<code>nano \/etc\/apt\/sources.list.d\/pgdg.list<\/code><br \/>\nadd the following line and save the file<br \/>\n<code>deb http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg main<\/code><\/li>\n<li>Import the repository signing key<br \/>\n<code>wget https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc<br \/>\napt-key add ACCC4CF8.asc<br \/>\n<\/code><\/li>\n<li>Update the package lists<br \/>\n<code>apt-get update<\/code><\/li>\n<li>Finally, install PostgreSQL as usual<br \/>\n<code>apt-get install postgresql<\/code><\/li>\n<li>You may install another version (e.g. 9.2), using:<br \/>\n<code>apt-get install postgresql-9.2<br \/>\n<\/code><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Setup current Debian version Version 9.1 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/lttt.vanabel.cn\/?p=4473\"> <span class=\"screen-reader-text\">Upgrade PostgreSQL 9.3 on Debian 7 Wheezy<\/span> \u9605\u8bfb\u66f4\u591a &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[351,593,658],"class_list":["post-4473","post","type-post","status-publish","format-standard","hentry","category-admin","tag-debian","tag-postpresql","tag-upgrade"],"_links":{"self":[{"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=\/wp\/v2\/posts\/4473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4473"}],"version-history":[{"count":0,"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=\/wp\/v2\/posts\/4473\/revisions"}],"wp:attachment":[{"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lttt.vanabel.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}