{"id":1823,"date":"2022-09-21T06:21:07","date_gmt":"2022-09-20T22:21:07","guid":{"rendered":"https:\/\/rogen.us\/how-to-install-postgresql-on-deepin\/"},"modified":"2022-09-21T06:21:07","modified_gmt":"2022-09-20T22:21:07","slug":"how-to-install-postgresql-on-deepin","status":"publish","type":"post","link":"https:\/\/rogen.us\/en\/how-to-install-postgresql-on-deepin\/","title":{"rendered":"How to install postgresql on deepin"},"content":{"rendered":"<p><![CDATA[\n\n<p>$ <code>sudo apt-get install curl ca-certificates gnupg<\/code>  #Install curl \u3001ca-certificates\u3001gnupg<\/p>\n\n\n\n\n\n<p>$ <code>curl https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo apt-key add -<\/code> #Download the installation source public key<\/p>\n\n\n\n\n\n<p>$ <code>sudo deepin-editor \/etc\/apt\/sources.list.d\/pgdg.list<\/code> #Enter the following command to create the file \/etc\/apt\/sources.list.d\/pgdg.list and open it for editing<\/p>\n\n\n\n\n\n<p>Copy and paste the following into the \/etc\/apt\/sources.list.d\/pgdg.list file and save it. <br \/>\n$ <strong>deb <a href=\"http:\/\/apt.postgresql.org\/pub\/repos\/apt\">http:\/\/apt.postgresql.org\/pub\/repos\/apt<\/a> buster-pgdg main<\/strong><\/p>\n\n\n\n\n\n<p>$ <code>sudo apt-get update<\/code> #update local repo<\/p>\n\n\n\n\n\n<p>$ <code>sudo apt-get install postgresql<\/code> #Install the lasted postgresql<\/p>\n\n\n\n\n\n<p>If you installed an old version before, just <code>ln<\/code> the <strong>pg<em>dump<\/strong> and <strong>pg<\/em>dumpall<\/strong> to the <strong>\/usr\/bin\/<\/strong> folder.<\/p>\n\n]]><\/p>\n","protected":false},"excerpt":{"rendered":"<p>$ sudo apt-get in&#8230;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[250],"tags":[],"class_list":["post-1823","post","type-post","status-publish","format-standard","hentry","category-coding-notes","wpcat-250-id"],"views":85,"_links":{"self":[{"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/posts\/1823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/comments?post=1823"}],"version-history":[{"count":0,"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/posts\/1823\/revisions"}],"wp:attachment":[{"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/media?parent=1823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/categories?post=1823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rogen.us\/en\/wp-json\/wp\/v2\/tags?post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}