{"id":145,"date":"2003-12-06T20:12:01","date_gmt":"2003-12-06T11:12:01","guid":{"rendered":"http:\/\/a-tak.com\/xoops2\/modules\/wordpress\/2003\/12\/06\/145"},"modified":"2003-12-06T20:12:01","modified_gmt":"2003-12-06T11:12:01","slug":"postgresql%e3%81%ae%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2%e4%b8%ad%e3%81%ab%e3%82%a8%e3%83%a9%e3%83%bc","status":"publish","type":"post","link":"https:\/\/a-tak.com\/blog\/2003\/12\/postgresql%e3%81%ae%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2%e4%b8%ad%e3%81%ab%e3%82%a8%e3%83%a9%e3%83%bc\/","title":{"rendered":"Postgresql\u306e\u30ea\u30b9\u30c8\u30a2\u4e2d\u306b\u30a8\u30e9\u30fc"},"content":{"rendered":"<div id=\"advads-3478321393\" class=\"advads-before-content-placement advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p>pg_dumpall -o > db.out<br \/>\n\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30c7\u30fc\u30bf\u3092<br \/>\npsql -e template1 < db.out\n\u307f\u305f\u3044\u306a\u611f\u3058\u3067\u30ea\u30b9\u30c8\u30a2\u3057\u3088\u3046\u3068\u3057\u305f\u3089\n\u300cFATAL 1: IDENT authentication failed for user \"postgres\"\u300d\n\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u3002\n\/var\/lib\/pgsql\/data\/pg_hba.conf\u306e\u8a2d\u5b9a\u3067\u3001\nlocal  all     ident   sameuser\n\u3092\nlocal   all     trust\n\u3068\u3059\u308b\u3068\u826f\u3044\u3088\u3046\u3067\u3059\u3002\n<a href=\"http:\/\/mike2mike.s21.xrea.com\/Linux_tips2.html\">\u3053\u3061\u3089<\/a>\u3092\u53c2\u8003\u306b\u3055\u305b\u3066\u9802\u304d\u307e\u3057\u305f\u3002<\/p><div id=\"advads-1781926945\" class=\"advads-content-placement-after-3rd-paragraph advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>pg_dumpall -o > db.out \u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30c7\u30fc\u30bf\u3092 psql -e template1 < db.out \u307f\u305f\u3044\u306a\u611f\u3058\u3067\u30ea\u30b9\u30c8\u30a2\u3057\u3088\u3046\u3068\u3057\u305f\u3089 \u300cFATAL 1: IDENT authenticat [&hellip;]\n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-145","post","type-post","status-publish","format-standard","hentry","category-linux"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts\/145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":0,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"wp:attachment":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}