{"id":1229,"date":"2020-05-02T22:47:07","date_gmt":"2020-05-02T13:47:07","guid":{"rendered":"http:\/\/168.138.214.208\/?p=1229"},"modified":"2024-04-02T19:36:43","modified_gmt":"2024-04-02T10:36:43","slug":"post-1229","status":"publish","type":"post","link":"https:\/\/nobunobu1717.site\/?p=1229","title":{"rendered":"Docker\u3067PostgresSQL\u3092\u52d5\u304b\u3059 (Mac)"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#i\"><span class=\"toc_number toc_depth_1\">1<\/span> \u6982\u8981<\/a><\/li><li><a href=\"#i-2\"><span class=\"toc_number toc_depth_1\">2<\/span> \u524d\u63d0<\/a><\/li><li><a href=\"#i-3\"><span class=\"toc_number toc_depth_1\">3<\/span> \u624b\u9806<\/a><\/li><\/ul><\/div>\n<h2><span id=\"i\">\u6982\u8981<\/span><\/h2>\n<p>Mac\u306eDocker\u4e0a\u3067PostgresSQL\u3092\u52d5\u304b\u3059\u3002<br \/>\n\u53c2\u8003\u5143<br \/>\nhttps:\/\/qiita.com\/oono_yoshi\/items\/e935d2132f456b4e0da9<\/p>\n<h2><span id=\"i-2\">\u524d\u63d0<\/span><\/h2>\n<p>Mac OS 10.15.4<\/p>\n\n\t<p style=\"color:#666;margin-bottom:5px;\">\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af<\/p>\n\t<div class=\"middle-ad\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\n<h2><span id=\"i-3\">\u624b\u9806<\/span><\/h2>\n<h3>Docker for Mac\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>Docker\u3092\u672a\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u5834\u5408\u306f\u4e0b\u8a18\u304b\u3089Docker\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002<br \/>\n(\u8a18\u4e8b\u4f5c\u6210\u6642\u306b\u306f\u6700\u65b0\u306e2.2.0.5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb)<br \/>\nhttps:\/\/hub.docker.com\/editions\/community\/docker-ce-desktop-mac<\/p>\n<p>\u753b\u9762\u53f3\u306bGet Docker\u30dc\u30bf\u30f3\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002<\/p>\n<h3>docker-compose.yml\u4f5c\u6210<\/h3>\n<p>\u4efb\u610f\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u4e0b\u8a18\u306edocker-compose.yml\u3092\u4f5c\u6210\u3059\u308b<\/p>\n<pre class=\"lang:yaml decode:true \">version: '3'\r\nvolumes:                           # \u203b\u30db\u30b9\u30c8OS\u3067\u6c38\u7d9a\u5316\r\n    postgres_data:\r\n        driver: 'local'\r\nservices:\r\n  postgres:\r\n    build:\r\n      context: .\/postgres\r\n      dockerfile: Dockerfile\r\n    container_name: \"postgres_db\"\r\n    environment:\r\n      POSTGRES_PASSWORD: postgres  #\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6(postgres)\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\r\n      POSTGRES_USER: test          #\u30e6\u30fc\u30b6\u30a2\u30ab\u30a6\u30f3\u30c8\r\n      POSTGRES_DB: testDb          #DB\u540d\r\n      TZ: \"Asia\/Tokyo\"\r\n    ports:\r\n      - 15432:5432  #\u30db\u30b9\u30c8OS\u306e15432\u3092\u30b3\u30f3\u30c6\u30ca\u5185\u306e5432\u306b\u30de\u30c3\u30d4\u30f3\u30b0\r\n    volumes:\r\n      - .\/postgres\/data:\/var\/lib\/postgresql\/data    # \u203b\u30db\u30b9\u30c8OS\u3067\u6c38\u7d9a\u5316\r\n      - .\/postgres\/sql:\/docker-entrypoint-initdb.d<\/pre>\n<h3>Dockerfile\u306e\u4f5c\u6210<\/h3>\n<p>\u4e0b\u8a18\u306e\u7528\u306bpompose\u30d5\u30a1\u30a4\u30eb\u306e\u76f4\u4e0b\u306bpostgres\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u4e2d\u306bDockerfile\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n<p>\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u69cb\u6210<\/p>\n<pre class=\"lang:batch decode:true \"> |- docker-compose.yml\r\n |- postgres      \r\n     |-Dockerfile\r\n     |-data\r\n     |-sql\r\n<\/pre>\n<p>Dockerfile<\/p>\n<pre class=\"lang:default decode:true \">FROM postgres:12.2\r\nRUN localedef -i ja_JP -c -f UTF-8 -A \/usr\/share\/locale\/locale.alias ja_JP.UTF-8\r\nENV LANG ja_JP.utf8\r\n<\/pre>\n<p>\u4eca\u56de\u306fpostgres 12.2\u3092\u4f7f\u7528\u3059\u308b\u304c\u4f7f\u7528\u3057\u305f\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5408\u308f\u305b\u3066\u5909\u66f4\u3092\u884c\u3046\u3002<\/p>\n\n\t<p style=\"color:#666;margin-bottom:5px;\">\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af<\/p>\n\t<div class=\"middle-ad\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\n<h3>\u8d77\u52d5<\/h3>\n<p>\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092docker-compose.yml\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u5185\u3067\u5b9f\u884c\u3059\u308b\u3002<br \/>\n(d\u3092\u3064\u3051\u308b\u4e8b\u3067\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u3067\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u3001\u305d\u306e\u5f8c\u4ed6\u306e\u30b3\u30de\u30f3\u30c9\u304c\u6253\u3066\u308b)<\/p>\n<pre class=\"lang:batch decode:true \" title=\"\u30b3\u30de\u30f3\u30c9\">docker-compose up -d<\/pre>\n<p>\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30b3\u30f3\u30c6\u30ca\u304c\u7acb\u3061\u4e0a\u304c\u3063\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n<pre class=\"lang:batch decode:true \" title=\"\u30b3\u30de\u30f3\u30c9\">docker-compose ps<\/pre>\n<p>\u30b3\u30f3\u30c6\u30ca\u304c\u7acb\u3061\u4e0a\u304c\u3063\u3066\u3044\u308c\u3070\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n<pre class=\"lang:batch decode:true \">   Name                  Command              State            Ports         \r\n-----------------------------------------------------------------------------\r\npostgres_db   docker-entrypoint.sh postgres   Up      0.0.0.0:15432-&gt;5432\/tcp<\/pre>\n<h3>\u63a5\u7d9a\u78ba\u8a8d<\/h3>\n<p>\u5b9f\u969b\u306b\u63a5\u7d9a\u3067\u304d\u308b\u304b\u78ba\u8a8d\u3092\u884c\u3046\u3002<br \/>\n\u4eca\u56de\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u3057\u3066DBbeaver\u3092\u4f7f\u7528\u3059\u308b\u3002<br \/>\n\u672a\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u5834\u5408\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u4e88\u3081\u884c\u3046\u3002<br \/>\n(\u8a18\u4e8b\u4f5c\u6210\u6642\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f7.0.3.202004191823)<\/p>\n<p>\u63a5\u7d9a\u8a2d\u5b9a\u3068\u3057\u3066\u4e0b\u8a18\u306b\u6ce8\u610f\u3059\u308b\u3002<br \/>\n1. \u63a5\u7d9a\u4f5c\u306flocalhost\u3067Port\u306f15432(docker-compose.yml\u3067\u8a2d\u5b9a\u3057\u305f\u5024\u3002)<br \/>\n2. \u63a5\u7d9adatabase\u306ftestDb(docker-compose.yml\u3067\u8a2d\u5b9a\u3057\u305f\u5024\u3002)<br \/>\n3. \u8a8d\u8a3c\u306ftest,password\u3092\u6307\u5b9a(docker-compose.yml\u3067\u8a2d\u5b9a\u3057\u305f\u5024\u3002)<\/p>\n<p><a href=\"http:\/\/168.138.214.208\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4.png\"><img src=\"http:\/\/168.138.214.208\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4-300x236.png\" alt=\"\" width=\"300\" height=\"236\" class=\"aligncenter size-medium wp-image-1234\" srcset=\"https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4-300x236.png 300w, https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4-768x604.png 768w, https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4-1024x806.png 1024w, https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/bb109014b777cdfe8d772548844feef4.png 1706w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u4e0b\u8a18\u306e\u3088\u3046\u306b\u63a5\u7d9a\u3067\u304d\u308c\u3070\u6210\u529f\u3002<\/p>\n<p><a href=\"http:\/\/168.138.214.208\/wp-content\/uploads\/2020\/05\/a0898f03ca4b0d74ff9ef8780d2c9a56.png\"><img src=\"http:\/\/168.138.214.208\/wp-content\/uploads\/2020\/05\/a0898f03ca4b0d74ff9ef8780d2c9a56-300x207.png\" alt=\"\" width=\"300\" height=\"207\" class=\"aligncenter size-medium wp-image-1235\" srcset=\"https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/a0898f03ca4b0d74ff9ef8780d2c9a56-300x207.png 300w, https:\/\/nobunobu1717.site\/wp-content\/uploads\/2020\/05\/a0898f03ca4b0d74ff9ef8780d2c9a56.png 626w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u6b62\u3081\u305f\u3044\u5834\u5408\u306f\u4e0b\u8a18<br \/>\ndocker-compose stop<\/p>\n<p>\u3053\u306e\u5f8c\u3001Rails\u3067\u52d5\u304b\u3059\u306b\u306f\u4e0b\u8a18\u3092\u53c2\u7167<br \/>\nhttps:\/\/qiita.com\/taKassi\/items\/8e43171aeda300b67213<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contents1 \u6982\u89812 \u524d\u63d03 \u624b\u9806 \u6982\u8981 Mac\u306eDocker\u4e0a\u3067PostgresSQL\u3092\u52d5\u304b\u3059\u3002 \u53c2\u8003\u5143 https:\/\/qiita.com\/oono_yoshi\/items\/e935d213 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":1236,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,31,27,28],"tags":[],"_links":{"self":[{"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/posts\/1229"}],"collection":[{"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1229"}],"version-history":[{"count":12,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/posts\/1229\/revisions"}],"predecessor-version":[{"id":3267,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/posts\/1229\/revisions\/3267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=\/wp\/v2\/media\/1236"}],"wp:attachment":[{"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nobunobu1717.site\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}