{"id":44839,"date":"2023-10-27T04:09:35","date_gmt":"2023-10-12T15:56:34","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/"},"modified":"2024-05-04T06:11:10","modified_gmt":"2024-05-03T22:11:10","slug":"44839-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/","title":{"rendered":""},"content":{"rendered":"<h1>\u69cb\u6210<\/h1>\n<h2>Go \u30a2\u30d7\u30ea<\/h2>\n<dl>\u30a2\u30d7\u30ea\u540d\uff0f\u30b3\u30f3\u30c6\u30ca\u540d<\/dl>\n<p>&nbsp;<\/p>\n<dl>app\uff0fapp<\/dl>\n<p>\u6a5f\u80fd<br \/>\nID\u3092\u6307\u5b9a\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u691c\u7d22\u30fb\u7d50\u679c\u8868\u793a<br \/>\n\u30d5\u30a9\u30eb\u30c0\u5171\u6709<br \/>\n\u30b3\u30f3\u30c6\u30ca\u4e2d\u306e go \u30d5\u30a1\u30a4\u30eb\u3092\u30db\u30b9\u30c8OS \u304b\u3089\u7de8\u96c6\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u305f\u3044\u306e\u3067\u3001<br \/>\n\u30db\u30b9\u30c8OS \u306e go \u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u30d5\u30a9\u30eb\u30c0\u3092 golang \u30b3\u30f3\u30c6\u30ca\u306b\u30de\u30a6\u30f3\u30c8<\/p>\n<h2>PostgreSQL<\/h2>\n<dl>\u30b3\u30f3\u30c6\u30ca\u540d<\/dl>\n<p>&nbsp;<\/p>\n<dl>postgres<\/dl>\n<p>&nbsp;<\/p>\n<dl>\u30e6\u30fc\u30b6\u540d\uff0f\u30d1\u30b9\u30ef\u30fc\u30c9<\/dl>\n<p>&nbsp;<\/p>\n<dl>app_user\uff0fpassword<\/dl>\n<p>&nbsp;<\/p>\n<dl>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\uff0f\u30c6\u30fc\u30d6\u30eb\u540d<\/dl>\n<p>&nbsp;<\/p>\n<dl>app_db\uff0fTEST_USER<\/dl>\n<p>&nbsp;<\/p>\n<dl>\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf<\/dl>\n<p>&nbsp;<\/p>\n<dl>\u30b3\u30f3\u30c6\u30ca\u8d77\u52d5\u6642\u306b\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u3068\u30c7\u30fc\u30bf\u633f\u5165\u3092\u884c\u3046<\/dl>\n<h2>\u30d5\u30a1\u30a4\u30eb\u914d\u7f6e<\/h2>\n<p>$GOPATH\/src\/app \u4e2d\u306b\u3001docker \u3068 go \u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u6b21\u306e\u3088\u3046\u306a\u5f62\u3067\u914d\u7f6e<\/p>\n<pre class=\"post-pre\"><code>\u2502\r\n\u251c\u2500docker-compose.yml\r\n\u251c\u2500docker\r\n\u2502  \u251c\u2500golang\r\n\u2502  \u2502   \u2514\u2500Dockerfile\r\n\u2502  \u2514\u2500postgres\r\n\u2502      \u251c\u2500Dockerfile\r\n\u2502      \u2514\u2500init\r\n\u2502          \u251c\u25001_create_table.sql\r\n\u2502          \u2514\u25002_insert_testdata.sql\r\n\u2514\u2500go\r\n    \u2514\u2500main.go\r\n<\/code><\/pre>\n<h1>Docker \u8a2d\u5b9a<\/h1>\n<h2>Docker Compose<\/h2>\n<p>\u300c\u4eca\u65e5\u304b\u3089\u59cb\u3081\u308bDocker\u3010docker-compose\u3092\u4f7f\u3063\u3066Go &amp; Mysql\u3092\u3088\u3057\u306a\u306b\u8d77\u52d5\u3057\u3088\u3046\u7de8\u3011\u300d1 \u3092\u53c2\u8003\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\"># docker-compose \u306e\u30d0\u30fc\u30b8\u30e7\u30f3<\/span>\r\n<span class=\"na\">version<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">3'<\/span>\r\n\r\n<span class=\"c1\"># \u5404\u30b3\u30f3\u30c6\u30ca\u306e\u60c5\u5831<\/span>\r\n<span class=\"na\">services<\/span><span class=\"pi\">:<\/span>\r\n\r\n  <span class=\"c1\"># postgres \u30b5\u30fc\u30d3\u30b9<\/span>\r\n  <span class=\"na\">postgres<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"c1\"># \u30b3\u30f3\u30c6\u30ca\u306e\u540d\u524d<\/span>\r\n    <span class=\"na\">container_name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres<\/span>\r\n    <span class=\"c1\"># Dockerfile \u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30d1\u30b9<\/span>\r\n    <span class=\"na\">build<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">context<\/span><span class=\"pi\">:<\/span> <span class=\"s\">.<\/span>\r\n      <span class=\"na\">dockerfile<\/span><span class=\"pi\">:<\/span> <span class=\"s\">.\/docker\/postgres\/Dockerfile<\/span>\r\n    <span class=\"c1\"># postgres \u8a2d\u5b9a<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">POSTGRES_USER=app_user<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">POSTGRES_PASSWORD=password<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">POSTGRES_DB=app_db<\/span>\r\n\r\n  <span class=\"c1\"># golang \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/span>\r\n  <span class=\"na\">app<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">container_name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">app<\/span>\r\n    <span class=\"c1\"># postgres \u3092\u30d3\u30eb\u30c9\u3057\u305f\u5f8c\u306b app \u3092\u30d3\u30eb\u30c9<\/span>\r\n    <span class=\"na\">depends_on<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">postgres<\/span>\r\n    <span class=\"c1\"># Dockerfile \u3092\u6307\u5b9a<\/span>\r\n    <span class=\"na\">build<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">context<\/span><span class=\"pi\">:<\/span> <span class=\"s\">.<\/span>\r\n      <span class=\"na\">dockerfile<\/span><span class=\"pi\">:<\/span> <span class=\"s\">.\/docker\/golang\/Dockerfile<\/span>\r\n    <span class=\"c1\"># GOPATH\u3092\u6307\u5b9a<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">GOPATH=\/go<\/span>\r\n    <span class=\"c1\"># \u30d5\u30a9\u30eb\u30c0\u5171\u6709\uff08\u30db\u30b9\u30c8OS:\u30b3\u30f3\u30c6\u30ca\uff09<\/span>\r\n    <span class=\"na\">volumes<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">.\/go:\/go\/src\/app\/go\/<\/span>\r\n    <span class=\"c1\"># docker-compose run \u5b9f\u884c\u6642\u306b\u5b9f\u884c\u3055\u308c\u308b\u30b3\u30de\u30f3\u30c9<\/span>\r\n    <span class=\"na\">command<\/span><span class=\"pi\">:<\/span> <span class=\"s\">go run main.go<\/span>\r\n<\/code><\/pre>\n<h2>Dockerfile<\/h2>\n<h3>app<\/h3>\n<pre class=\"post-pre\"><code>FROM golang:1.9\r\n\r\n# \u30b3\u30f3\u30c6\u30ca\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u5909\u66f4\r\nWORKDIR \/go\/src\/denki\/go\r\n# \u30db\u30b9\u30c8OS\u306e .\/go \u306e\u4e2d\u8eab\u3092\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u8ffd\u52a0\r\nADD .\/go .\r\n\r\n# \u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\nRUN go get github.com\/lib\/pq\r\n<\/code><\/pre>\n<h3>postgres<\/h3>\n<pre class=\"post-pre\"><code>FROM postgres:latest\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.UTF-\r\n\r\n# \u521d\u671f\u5316\u7528 sql \u30d5\u30a1\u30a4\u30eb\u3092\u3001\u30b3\u30f3\u30c6\u30ca\u5185\u306e\u6240\u5b9a\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30b3\u30d4\u30fc\r\nCOPY .\/docker\/postgres\/init\/*.sql \/docker-entrypoint-initdb.d\/\r\n<\/code><\/pre>\n<p>\/docker-entrypoint-initdb.d\/ \u5185\u306b sql \u30d5\u30a1\u30a4\u30eb\u3092\u914d\u7f6e\u3059\u308b\u3068\u3001\u305d\u308c\u3089\u3092\u81ea\u52d5\u3067\u5b9f\u884c\u3057\u3066\u304f\u308c\u308b\u3089\u3057\u30442<\/p>\n<h1>\u305d\u306e\u4ed6\u30d5\u30a1\u30a4\u30eb<\/h1>\n<h2>SQL\u30d5\u30a1\u30a4\u30eb<\/h2>\n<p>\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE TEST_USER (\r\n    user_id BIGINT PRIMARY KEY,\r\n    user_password VARCHAR(20) NOT NULL\r\n);\r\n<\/code><\/pre>\n<p>\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u633f\u5165<\/p>\n<pre class=\"post-pre\"><code>DELETE FROM TEST_USER;\r\nINSERT INTO TEST_USER VALUES(1, 'password1');\r\nINSERT INTO TEST_USER VALUES(2, 'password2');\r\n<\/code><\/pre>\n<h2>Go<\/h2>\n<p>\u66f8\u7c4d\u300cGo\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u5b9f\u8df5\u5165\u9580\u300d3\u3092\u53c2\u8003\u306b\u3057\u307e\u3057\u305f<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">package<\/span> <span class=\"n\">main<\/span>\r\n\r\n<span class=\"k\">import<\/span> <span class=\"p\">(<\/span>\r\n    <span class=\"s\">\"database\/sql\"<\/span>\r\n    <span class=\"s\">\"fmt\"<\/span>\r\n    <span class=\"s\">\"log\"<\/span>\r\n\r\n    <span class=\"c\">\/\/ postgres \u30c9\u30e9\u30a4\u30d0<\/span>\r\n    <span class=\"n\">_<\/span> <span class=\"s\">\"github.com\/lib\/pq\"<\/span>\r\n<span class=\"p\">)<\/span>\r\n\r\n<span class=\"c\">\/\/ TestUser : \u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf<\/span>\r\n<span class=\"k\">type<\/span> <span class=\"n\">TestUser<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">UserID<\/span>   <span class=\"kt\">int<\/span>\r\n    <span class=\"n\">Password<\/span> <span class=\"kt\">string<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ \u30e1\u30a4\u30f3\u95a2\u6570<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"n\">main<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n\r\n    <span class=\"c\">\/\/ Db: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u30cf\u30f3\u30c9\u30e9<\/span>\r\n    <span class=\"k\">var<\/span> <span class=\"n\">Db<\/span> <span class=\"o\">*<\/span><span class=\"n\">sql<\/span><span class=\"o\">.<\/span><span class=\"n\">DB<\/span>\r\n    <span class=\"c\">\/\/ Db\u306e\u521d\u671f\u5316<\/span>\r\n    <span class=\"n\">Db<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">sql<\/span><span class=\"o\">.<\/span><span class=\"n\">Open<\/span><span class=\"p\">(<\/span><span class=\"s\">\"postgres\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"host=postgres user=app_user password=password dbname=app_db sslmode=disable\"<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">log<\/span><span class=\"o\">.<\/span><span class=\"n\">Fatal<\/span><span class=\"p\">(<\/span><span class=\"n\">err<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"c\">\/\/ SQL\u6587\u306e\u69cb\u7bc9<\/span>\r\n    <span class=\"n\">sql<\/span> <span class=\"o\">:=<\/span> <span class=\"s\">\"SELECT user_id, user_password FROM TEST_USER WHERE user_id=$1;\"<\/span>\r\n\r\n    <span class=\"c\">\/\/ preparedstatement \u306e\u751f\u6210<\/span>\r\n    <span class=\"n\">pstatement<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">Db<\/span><span class=\"o\">.<\/span><span class=\"n\">Prepare<\/span><span class=\"p\">(<\/span><span class=\"n\">sql<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">log<\/span><span class=\"o\">.<\/span><span class=\"n\">Fatal<\/span><span class=\"p\">(<\/span><span class=\"n\">err<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"c\">\/\/ \u691c\u7d22\u30d1\u30e9\u30e1\u30fc\u30bf\uff08\u30e6\u30fc\u30b6ID\uff09<\/span>\r\n    <span class=\"n\">queryID<\/span> <span class=\"o\">:=<\/span> <span class=\"m\">1<\/span>\r\n    <span class=\"c\">\/\/ \u691c\u7d22\u7d50\u679c\u683c\u7d0d\u7528\u306e TestUser<\/span>\r\n    <span class=\"k\">var<\/span> <span class=\"n\">testUser<\/span> <span class=\"n\">TestUser<\/span>\r\n\r\n    <span class=\"c\">\/\/ queryID \u3092\u57cb\u3081\u8fbc\u307f SQL \u306e\u5b9f\u884c\u3001\u691c\u7d22\u7d50\u679c1\u4ef6\u306e\u53d6\u5f97<\/span>\r\n    <span class=\"n\">err<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pstatement<\/span><span class=\"o\">.<\/span><span class=\"n\">QueryRow<\/span><span class=\"p\">(<\/span><span class=\"n\">queryID<\/span><span class=\"p\">)<\/span><span class=\"o\">.<\/span><span class=\"n\">Scan<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">testUser<\/span><span class=\"o\">.<\/span><span class=\"n\">UserID<\/span><span class=\"p\">,<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">testUser<\/span><span class=\"o\">.<\/span><span class=\"n\">Password<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">log<\/span><span class=\"o\">.<\/span><span class=\"n\">Fatal<\/span><span class=\"p\">(<\/span><span class=\"n\">err<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"c\">\/\/ \u691c\u7d22\u7d50\u679c\u306e\u8868\u793a<\/span>\r\n    <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"n\">testUser<\/span><span class=\"o\">.<\/span><span class=\"n\">UserID<\/span><span class=\"p\">,<\/span> <span class=\"n\">testUser<\/span><span class=\"o\">.<\/span><span class=\"n\">Password<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h1>Docker Compose \u306e\u5b9f\u884c<\/h1>\n<p>\u30b7\u30a7\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c<\/p>\n<pre class=\"post-pre\"><code>$ docker-compose build  # \u30a4\u30e1\u30fc\u30b8\u306e\u4f5c\u6210\r\n$ docker-compose up     # \u30b3\u30f3\u30c6\u30ca\u306e\u4f5c\u6210\u3001\u8d77\u52d5\r\n<\/code><\/pre>\n<p>\u30b3\u30f3\u30c6\u30ca\u306e\u8d77\u52d5\u9806\u5e8f\u3092\u6307\u5b9a\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3001postgres \u3088\u308a\u524d\u306b app \u30b3\u30f3\u30c6\u30ca\u304c\u5148\u306b\u8d77\u52d5\u3059\u308b\u5834\u5408\u304c\u3042\u308b\u3002<br \/>\n\u305d\u3046\u306a\u308b\u3068 DB \u306b\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u30a8\u30e9\u30fc\u304c\u5410\u304b\u308c\u308b<\/p>\n<pre class=\"post-pre\"><code>app     | 2018\/12\/15 13:50:02 dial tcp 172.29.0.2:5432: getsockopt: connection refused\r\n<\/code><\/pre>\n<p>\u4e00\u56de Ctrl+C \u3067\u30b3\u30f3\u30c6\u30ca\u3092\u505c\u6b62\u3055\u305b\u3001\u3082\u3046\u4e00\u5ea6 docker-compose up \u3067\u30b3\u30f3\u30c6\u30ca\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001app \u306e\u5b9f\u884c\u7d50\u679c\uff08 app | 1 password1 \uff09\u304c\u8868\u793a\u3055\u308c\u308b<\/p>\n<p>\u203b\u8d77\u52d5\u9806\u5e8f\u3092\u6307\u5b9a\u3057\u305f\u3044\u3068\u304d\u306f\u3001docker-compose \u306e entrypoint \u3068\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3088\u3063\u3066\u3001DB\u30b3\u30f3\u30c6\u30ca\u304c\u8d77\u52d5\u3059\u308b\u307e\u3067\u30a2\u30d7\u30ea\u8d77\u52d5\u3092\u5f85\u6a5f\u3055\u305b\u308b\u65b9\u6cd5\u304c\u3042\u308b 4<\/p>\n<p>\u30b3\u30f3\u30c6\u30ca\u306e\u505c\u6b62\u30fb\u7834\u68c4<\/p>\n<pre class=\"post-pre\"><code>docker-compose down\r\n<\/code><\/pre>\n<p>\u30a4\u30e1\u30fc\u30b8\u306e\u7834\u68c4<\/p>\n<pre class=\"post-pre\"><code>docker image rm app_app app_postgres\r\n<\/code><\/pre>\n<h1>\u8a70\u307e\u3063\u305f\u3068\u3053\u308d<\/h1>\n<h2>go get \u306b\u5931\u6557\u3059\u308b<\/h2>\n<p>\u30a4\u30e1\u30fc\u30b8\u306e\u30d3\u30eb\u30c9\u306e\u969b\u3001go get \u306b\u304a\u3044\u3066<\/p>\n<pre class=\"post-pre\"><code>cannot find package \"\u30d1\u30c3\u30b1\u30fc\u30b8\u540d\" ... (from $GOROOT) ... (from $GOPATH)\r\n<\/code><\/pre>\n<p>\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u30d3\u30eb\u30c9\u306b\u5931\u6557\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3002\u539f\u56e0\u3068\u3057\u3066\u3001<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30d1\u30c3\u30b1\u30fc\u30b8\u81ea\u4f53\u304c\u5b58\u5728\u3057\u306a\u3044\u304b\u3001\u30d1\u30b9\u304c\u9593\u9055\u3063\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">golang \u30a4\u30e1\u30fc\u30b8\u306b git \u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u306a\u30445<\/ul>\n<p>\u304c\u3042\u308b\u3089\u3057\u3044\u306e\u3067\u3001URI\u3092\u78ba\u8a8d\u3059\u308b\u306a\u308a\u3001\u30a4\u30e1\u30fc\u30b8\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092 golang:1.9 \u306b\u5909\u66f4\u3059\u308b\u7b49\u3059\u308b<\/p>\n<h2>postgres \u30b3\u30f3\u30c6\u30ca\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044<\/h2>\n<p>main.go \u306e DB \u63a5\u7d9a\u8a2d\u5b9a\u3067<\/p>\n<pre class=\"post-pre\"><code>var Db *sql.DB\r\n\/\/ Db\u306e\u521d\u671f\u5316\r\nDb, err := sql.Open(\"postgres\", \"host=localhost user=...\r\n<\/code><\/pre>\n<p>\u306e\u3088\u3046\u306b host=localhost \u3068\u3059\u308b\u3068<\/p>\n<pre class=\"post-pre\"><code>app  | ... dial tcp 127.0.0.1:5432: connect: connection refused\r\n<\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u30a8\u30e9\u30fc\u304c\u5410\u304b\u308c\u308b\u3002host \u306e\u5024\u306f\u3001\u63a5\u7d9a\u5148\u306e\u30b3\u30f3\u30c6\u30ca\u540d\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b6 \u306e\u3067\u3001host=postgres \u306b\u4fee\u6b63\u3057\u3066\u89e3\u6c7a<\/p>\n<div>\n<p>https:\/\/qiita.com\/yu-croco\/items\/0c0d5083298f7db9e1bb\u00a0\u21a9<\/p>\n<p>https:\/\/qiita.com\/hirosemi\/items\/199a3c753130c12d52f1\u00a0\u21a9<\/p>\n<p>https:\/\/book.impress.co.jp\/books\/1115101145\u00a0\u21a9<\/p>\n<p>http:\/\/docs.docker.jp\/compose\/startup-order.html\u00a0\u21a9<\/p>\n<p>https:\/\/stackoverflow.com\/questions\/44210502\/docker-compose-cannot-find-package-golang\u00a0\u21a9<\/p>\n<p>https:\/\/qiita.com\/unvavo\/items\/7b3d1ef9403f6b4b8456\u00a0\u21a9<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u69cb\u6210 Go \u30a2\u30d7\u30ea \u30a2\u30d7\u30ea\u540d\uff0f\u30b3\u30f3\u30c6\u30ca\u540d &nbsp; app\uff0fapp \u6a5f\u80fd ID\u3092\u6307\u5b9a\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u691c\u7d22\u30fb\u7d50 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-44839","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>- Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:description\" content=\"\u69cb\u6210 Go \u30a2\u30d7\u30ea \u30a2\u30d7\u30ea\u540d\uff0f\u30b3\u30f3\u30c6\u30ca\u540d &nbsp; app\uff0fapp \u6a5f\u80fd ID\u3092\u6307\u5b9a\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u691c\u7d22\u30fb\u7d50 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-12T15:56:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T22:11:10+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/\",\"name\":\"- Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-10-12T15:56:34+00:00\",\"dateModified\":\"2024-05-03T22:11:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"- Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/","og_locale":"zh_CN","og_type":"article","og_description":"\u69cb\u6210 Go \u30a2\u30d7\u30ea \u30a2\u30d7\u30ea\u540d\uff0f\u30b3\u30f3\u30c6\u30ca\u540d &nbsp; app\uff0fapp \u6a5f\u80fd ID\u3092\u6307\u5b9a\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u691c\u7d22\u30fb\u7d50 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-10-12T15:56:34+00:00","article_modified_time":"2024-05-03T22:11:10+00:00","author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/","name":"- Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-10-12T15:56:34+00:00","dateModified":"2024-05-03T22:11:10+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/44839-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=44839"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44839\/revisions"}],"predecessor-version":[{"id":96590,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44839\/revisions\/96590"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=44839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=44839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=44839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}