{"id":874,"date":"2016-04-08T13:25:40","date_gmt":"2016-04-08T04:25:40","guid":{"rendered":"https:\/\/www.choco.org.uk\/chocodb\/?p=874"},"modified":"2016-04-08T13:29:05","modified_gmt":"2016-04-08T04:29:05","slug":"linux%e3%81%a7%e3%81%aepostgresql%e3%81%ae%e3%82%a2%e3%83%83%e3%83%97%e3%83%87%e3%83%bc%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.choco.org.uk\/chocodb\/?p=874","title":{"rendered":"Linux\u3067\u306ePostgreSQL\u306e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8"},"content":{"rendered":"<p>\u4ed5\u4e8b\u3067\u300c9.4.1\u300d\u3092\u4f7f\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u3082\u4e0d\u5177\u5408\u304c\u3042\u308b\u3063\u307d\u3044\u306e\u3067\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\u3001\u30b0\u30b0\u3063\u3066\u3082\u610f\u5916\u306b\u51fa\u3066\u6765\u306a\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<p>\u3010\u76ee\u7684\u3011<br \/>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300cPostgreSQL\u300d\u306e\u30ea\u30d3\u30b8\u30e7\u30f3\u3092\u65b0\u3057\u3044\u3082\u306e\u306b\u3059\u308b\u4e8b\u306b\u3088\u308a\u3001\u65e2\u77e5\u306e\u4e0d\u5177\u5408\u3092\u89e3\u6d88\u3059\u308b\u3002<\/p>\n<p>\u5bfe\u8c61\u306ePostgreSQL<br \/>\n\u73fe\u884c\uff1a9.4.1 64<br \/>\n\u21d29.4.7 64<\/p>\n<p>\u3010\u624b\u9806\u3011<br \/>\n\uff11\uff0e\u5bfe\u8c61\u30b5\u30fc\u30d0\u30fc\u306bSSH\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3002<br \/>\n\uff12\uff0e\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u30fc\uff08SU\uff09\u6a29\u9650\u306b\u306a\u308b\u3002<\/p>\n<p>\uff13\uff0eYum\u30c1\u30a7\u30c3\u30af<br \/>\n\uff1eyum -check-update<br \/>\npostgresql94.x86_64                   9.4.7-1PGDG.rhel6                  pgdg94<br \/>\npostgresql94-contrib.x86_64           9.4.7-1PGDG.rhel6                  pgdg94<br \/>\npostgresql94-libs.x86_64              9.4.7-1PGDG.rhel6                  pgdg94<br \/>\npostgresql94-odbc.x86_64              09.03.0400-1PGDG.rhel6             pgdg94<br \/>\npostgresql94-server.x86_64            9.4.7-1PGDG.rhel6                  pgdg94<\/p>\n<p>\uff14\uff0eApache\u3092\u505c\u6b62<br \/>\n\uff1e\/etc\/init.d\/httpd stop<\/p>\n<p>\uff15\uff0ePostgreSQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u308b\u3002<br \/>\n\u30fb\u30c7\u30fc\u30bf\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<br \/>\n\uff1esu postgres<br \/>\nbash-4.1$ pg_dumpall -o > pg_dumpall20160407<\/p>\n<p>\uff16\uff0ePostgreSQL\u306e\u505c\u6b62<br \/>\nsu postgres<br \/>\nbash-4.1$ \/usr\/pgsql-9.4\/bin\/pg_ctl -D \/var\/lib\/pgsql\/9.4\/data stop<\/p>\n<p>\uff17\uff0ePostgreSQL\u3092\u629c\u3051\u308b<br \/>\nbash-4.1$ exit<\/p>\n<p>\uff18\uff0e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u958b\u59cb<br \/>\n\uff1eyum update postgresql94.x86_64<\/p>\n<p>================================================================================<br \/>\n \u30d1\u30c3\u30b1\u30fc\u30b8                \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<br \/>\n                                       \u30d0\u30fc\u30b8\u30e7\u30f3             \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc<br \/>\n                                                                           \u5bb9\u91cf<br \/>\n================================================================================<br \/>\n\u66f4\u65b0:<br \/>\n postgresql94              x86_64      9.4.7-1PGDG.rhel6      pgdg94      1.0 M<br \/>\n\u4f9d\u5b58\u6027\u95a2\u9023\u3067\u306e\u66f4\u65b0\u3092\u3057\u307e\u3059\u3002:<br \/>\n postgresql94-contrib      x86_64      9.4.7-1PGDG.rhel6      pgdg94      532 k<br \/>\n postgresql94-libs         x86_64      9.4.7-1PGDG.rhel6      pgdg94      195 k<br \/>\n postgresql94-server       x86_64      9.4.7-1PGDG.rhel6      pgdg94      4.4 M<\/p>\n<p>\u7dcf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5bb9\u91cf: 6.1 M<br \/>\n\u3053\u308c\u3067\u3044\u3044\u3067\u3059\u304b? [y\/N]y<\/p>\n<p>\uff19\uff0e\u5b9f\u884c\uff08\uff59\u30ad\u30fc\u3092\u62bc\u3059\uff09<br \/>\n(1\/4): postgresql94-9.4.7-1PGDG.rhel6.x86_64.rpm         | 1.0 MB     00:01<br \/>\n(2\/4): postgresql94-contrib-9.4.7-1PGDG.rhel6.x86_64.rpm | 532 kB     00:00<br \/>\n(3\/4): postgresql94-libs-9.4.7-1PGDG.rhel6.x86_64.rpm    | 195 kB     00:00<br \/>\n(4\/4): postgresql94-server-9.4.7-1PGDG.rhel6.x86_64.rpm  | 4.4 MB     00:01<\/p>\n<p>\u4e0a\u8a18\u66f4\u65b0\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/p>\n<p>\uff1e\u5b8c\u4e86\u3057\u307e\u3057\u305f\uff01\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n<p>10\uff0ePostgreSQL\u306e\u958b\u59cb<br \/>\n\u21d2\u4e0d\u8981\u3067\u3057\u305f\u3002<br \/>\nsu postgres<br \/>\nbash-4.1$ \/usr\/pgsql-9.4\/bin\/pg_ctl -D \/var\/lib\/pgsql\/9.4\/data start<\/p>\n<p>\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304c\u5b8c\u4e86\u3059\u308b\u3068\u81ea\u52d5\u8d77\u52d5\u3057\u3066\u308b\u3089\u3057\u3044\u3002<\/p>\n<p>\u5ff5\u306e\u305f\u3081\u3001\u30ea\u30b9\u30bf\u30fc\u30c8\u3092\u304b\u3051\u305f\u3002<br \/>\n\uff1e\/usr\/pgsql-9.4\/bin\/pg_ctl -D \/var\/lib\/pgsql\/9.4\/data restart<\/p>\n<p>PostgreSQL\u3092\u629c\u3051\u308b<br \/>\nbash-4.1$ exit<\/p>\n<p>11\uff0eApache\u3092\u8d77\u52d5<br \/>\n\uff1e\/etc\/init.d\/httpd start<br \/>\n\u5b8c\u4e86<\/p>\n<p>12\uff0eURL\u3092\u78ba\u8a8d<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"ltJhV95nd9\"><p><a href=\"https:\/\/www.choco.org.uk\/chocodb\/\">\u3054\u6848\u5185<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u3054\u6848\u5185&#8221; &#8212; Choco Soft\" src=\"https:\/\/www.choco.org.uk\/chocodb\/?embed=true#?secret=KFd5cRMMtK#?secret=ltJhV95nd9\" data-secret=\"ltJhV95nd9\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u304a\u308f\u308a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ed5\u4e8b\u3067\u300c9.4.1\u300d\u3092\u4f7f\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u3082\u4e0d\u5177\u5408\u304c\u3042\u308b\u3063\u307d\u3044\u306e\u3067\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\u3001\u30b0\u30b0\u3063\u3066\u3082\u610f\u5916\u306b\u51fa\u3066\u6765\u306a\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002 \u3010\u76ee\u7684\u3011 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300cPostgreSQL\u300d\u306e\u30ea\u30d3\u30b8\u30e7\u30f3\u3092\u65b0\u3057\u3044\u3082\u306e\u306b\u3059\u308b [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15,39],"tags":[48],"class_list":["post-874","post","type-post","status-publish","format-standard","hentry","category-pervasivesql","category-server","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=874"}],"version-history":[{"count":3,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":877,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/874\/revisions\/877"}],"wp:attachment":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}