{"id":64,"date":"2010-02-25T09:49:53","date_gmt":"2010-02-25T00:49:53","guid":{"rendered":"http:\/\/www2.lancard.com\/blog\/?p=64"},"modified":"2025-03-12T11:31:40","modified_gmt":"2025-03-12T02:31:40","slug":"os-x-%e3%81%ab%e5%b0%8e%e5%85%a5%e3%81%97%e3%81%9f-postgresql-%e3%81%ae%e8%87%aa%e5%8b%95%e8%b5%b7%e5%8b%95%e3%82%92%e7%84%a1%e5%8a%b9%e3%81%ab%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.lancard.com\/blog\/2010\/02\/25\/os-x-%e3%81%ab%e5%b0%8e%e5%85%a5%e3%81%97%e3%81%9f-postgresql-%e3%81%ae%e8%87%aa%e5%8b%95%e8%b5%b7%e5%8b%95%e3%82%92%e7%84%a1%e5%8a%b9%e3%81%ab%e3%81%99%e3%82%8b\/","title":{"rendered":"OS X \u306b\u5c0e\u5165\u3057\u305f PostgreSQL \u306e\u81ea\u52d5\u8d77\u52d5\u3092\u7121\u52b9\u306b\u3059\u308b"},"content":{"rendered":"<p>PostgreSQL \u304c\u81ea\u52d5\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u305f\u306e\u3067\u6b62\u3081\u3068\u304d\u307e\u3059\u3002\u958b\u767a\u30fb\u691c\u8a3c\u7528\u3067\u3059\u306e\u3067\u3002<\/p>\n<p>OS X \u3067\u306f daemon \u306e\u8d77\u52d5\u306f launchctl \u30b3\u30de\u30f3\u30c9\u3067\u8a2d\u5b9a\u3067\u304d\u308b\u3088\u3046\u3067\u3059\u3002\u62e1\u5f35\u5b50\u304c plist \u306a\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3067\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3057\u3066\u3044\u308b\u305d\u3046\u306a\u306e\u3067\u63a2\u3057\u307e\u3059\u3002<\/p>\n<pre lang=\"Bash\" line=\"1\">\n$ locate plist | grep postgres\n\/Library\/LaunchDaemons\/com.edb.launchd.postgresql-8.4.plist\n\/Library\/PostgreSQL\/8.4\/uninstall-postgresql.app\/Contents\/Info.plist\n<\/pre>\n<p>com.edb.launchd.postgresql-8.4.plist \u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u306e\u3088\u3046\u3067\u3059\u3002<\/p>\n<pre lang=\"Bash\" line=\"1\">\n$ sudo launchctl unload -w \/Library\/LaunchDaemons\/com.edb.launchd.postgresql-8.4.plist\n<\/pre>\n<p>\u518d\u8d77\u52d5\u3057\u3066\u78ba\u8a8d\u3002<\/p>\n<pre lang=\"Bash\" line=\"1\">\n$ ps ax | grep postgres\n  419 s000  S+     0:00.00 grep postgres\n<\/pre>\n<p>\u304a\u3051\u304a\u3051\u3002<\/p>\n<p>\u9006\u306b\u81ea\u52d5\u8d77\u52d5\u3055\u305b\u305f\u3044\u3068\u304d\u306f<\/p>\n<pre lang=\"Bash\" line=\"1\">\n$ sudo launchctl load -w \/Library\/LaunchDaemons\/com.edb.launchd.postgresql-8.4.plist\n<\/pre>\n<p>\u3067\u3059\u304b\u306d\u3002<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-facebook nolightbox\" data-provider=\"facebook\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64&amp;t=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B&amp;s=100&amp;p[url]=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64&amp;p[images][0]=&amp;p[title]=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"Facebook\" title=\"Share on Facebook\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/facebook.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"http:\/\/twitter.com\/share?url=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64&amp;text=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&amp;url=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64&amp;title=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-tumblr nolightbox\" data-provider=\"tumblr\" target=\"_blank\" rel=\"nofollow\" title=\"Share on tumblr\" href=\"https:\/\/tumblr.com\/share?s=&amp;v=3&amp;t=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B&amp;u=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"tumblr\" title=\"Share on tumblr\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/tumblr.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=OS%20X%20%E3%81%AB%E5%B0%8E%E5%85%A5%E3%81%97%E3%81%9F%20PostgreSQL%20%E3%81%AE%E8%87%AA%E5%8B%95%E8%B5%B7%E5%8B%95%E3%82%92%E7%84%A1%E5%8A%B9%E3%81%AB%E3%81%99%E3%82%8B&amp;body=%E3%82%B7%E3%82%A7%E3%82%A2%E3%81%99%E3%82%8B%EF%BC%9A:%20https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F64\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u304c\u81ea\u52d5\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u305f\u306e\u3067\u6b62\u3081\u3068\u304d\u307e\u3059\u3002\u958b\u767a\u30fb\u691c\u8a3c\u7528\u3067\u3059\u306e\u3067\u3002 OS X \u3067\u306f daemon \u306e\u8d77\u52d5\u306f launchctl \u30b3\u30de\u30f3\u30c9\u3067\u8a2d\u5b9a\u3067\u304d\u308b\u3088\u3046\u3067\u3059\u3002\u62e1\u5f35\u5b50\u304c plist \u306a\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[14,135],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-1","tag-os-x","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":8,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":4709,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions\/4709"}],"wp:attachment":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}