{"id":294,"date":"2010-05-17T21:14:08","date_gmt":"2010-05-17T05:14:08","guid":{"rendered":"http:\/\/blog.longwin.com.tw\/?p=294"},"modified":"2010-05-17T21:14:08","modified_gmt":"2010-05-17T05:14:08","slug":"cetnos-5.5-postgresql-81-84","status":"publish","type":"post","link":"https:\/\/blog.fhl.net\/?p=294","title":{"rendered":"CetnOS 5.5 postgresql 81\u63db\u5230 84\u7684\u65b9\u6cd5"},"content":{"rendered":"<p>\n\u53c3\u8003\uff1a <a href=\"http:\/\/blog.lystor.org.ua\/2010\/05\/upgrading-postgresql-81-to-84-centos-55.html\">\u9019\u500b\u7db2\u9801<\/a>&nbsp;\n<\/p>\n<p>\n&nbsp;su postgres\n<\/p>\n<p>\ncd&nbsp;\n<\/p>\n<p>\n&nbsp;cd backups\/\n<\/p>\n<p>\n&nbsp;pg_dumpall &#8211;globals-only &gt; globals.sql\n<\/p>\n<p>\n&nbsp;psql -d postgres\n<\/p>\n<p>\nselect * from pg_database&nbsp; \u770b\u770b\u6709\u90a3\u4e9b\u8cc7\u6599\u5eab\n<\/p>\n<p>\npostgresql template0 template1 \u90fd\u662f\u7cfb\u7d71\u8cc7\u6599\u5eab\u4e0d\u7528\u8655\u7406\uff0c\u5176\u4ed6\u7684\u90fd\n<\/p>\n<pre>\r\npg_dump --create --oids --format=c --verbose --file dbx dbx   \u9019\u6a23dump\u51fa\u4f86\uff0c\u5982\u679c\u7de8\u78bc\u662f MUL_INTERNAL\u7684\uff0c\u8981\r\n<\/pre>\n<pre>\r\npg_dump -E big5 --create --oids --format=c --verbose --file dbx dbx \r\n<\/pre>\n<pre>\r\n&nbsp;exit\r\n<\/pre>\n<pre>\r\n&nbsp;\/etc\/init.d\/postgresql stop\r\n<\/pre>\n<pre>\r\n&nbsp;cd ~postgres\r\n<\/pre>\n<pre>\r\n&nbsp;mv data\/ data.old\r\n<\/pre>\n<pre>\r\nyum remove postgresql postgresql-server postgresql-devel\r\n<\/pre>\n<pre>\r\n&nbsp;yum install postgresql84 postgresql84-server postgresql84-devel\r\n<\/pre>\n<pre>\r\n\/\/\u4fe1\u671b\u611b\u7ad9\u8981\u8655\u7406\u4e00\u4e0bsoft link \r\n<\/pre>\n<pre>\r\n&nbsp;\/etc\/init.d\/postgresql initdb\r\n<\/pre>\n<pre>\r\n&nbsp;chkconfig --level 35 postgresql on\r\n<\/pre>\n<pre>\r\n&nbsp;cd ~postgres\/data\r\n<\/pre>\n<pre>\r\n&nbsp;cp ..\/data.old\/pg_hba.conf .\r\n<\/pre>\n<pre>\r\n&nbsp;\/etc\/init.d\/postgresql start\r\n<\/pre>\n<pre>\r\nsu - postgres\r\ncd  backups\r\n<\/pre>\n<pre>\r\n&nbsp;psql -f globals.sql\r\n<\/pre>\n<pre>\r\n\u628a\u525b\u525b\u5099\u4efd\u51fa\u4f86\u7684 db\u90fd\r\n<\/pre>\n<pre>\r\n&nbsp;pg_restore --create -d postgres dbX \r\n<\/pre>\n<pre>\r\nrestore \u9032\u4f86 \r\n<\/pre>\n<pre>\r\n&nbsp;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u53c3\u8003\uff1a \u9019\u500b\u7db2\u9801&nbsp; &nbsp;su postgres cd&nbsp; &nbsp;cd back &hellip; <a href=\"https:\/\/blog.fhl.net\/?p=294\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">CetnOS 5.5 postgresql 81\u63db\u5230 84\u7684\u65b9\u6cd5<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-e"],"_links":{"self":[{"href":"https:\/\/blog.fhl.net\/index.php?rest_route=\/wp\/v2\/posts\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fhl.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fhl.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fhl.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fhl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=294"}],"version-history":[{"count":0,"href":"https:\/\/blog.fhl.net\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fhl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fhl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fhl.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}