想要使用 docker-compose
同时运行 API 应用程序和 PostgreSQL 数据库。
docker-compose
文件:
version: '3'
volumes:
database_data:
driver: local
services:
db:
image: postgres:latest
volumes:
- database_data:/var/lib/postgresql/data
api:
build: ./api
expose:
- 8080
ports:
- 8080:8080
volumes:
- ./api:/usr/src/app/
links:
- db
environment:
- PGHOST=db
- PGDATABASE=postgres
- PGUSER=postgres
API main.go
文件:
func main() {
db, err = gorm.Open("postgres", "host=db port=5432 user=postgres dbname=postgres")
// ...
}
运行服务时,从日志中收到以下消息:
api_1 | [GIN] 2018/06/22 - 07:31:10 | 404 | 1.4404ms | 172.20.0.1 | GET /posts
api_1 |
api_1 | (sql: database is closed)
api_1 | [2018-06-22 07:31:10]
api_1 |
api_1 | (sql: database is closed)
api_1 | [2018-06-22 07:31:10]
api_1 | [GIN] 2018/06/22 - 07:32:14 | 403 | 15.6µs | 172.20.0.1 | GET /posts
db_1 | 2018-06-22 07:34:27.296 UTC [81] FATAL: role "root" does not exist
db_1 | 2018-06-22 07:34:36.897 UTC [90] FATAL: role "root" does not exist
这种方式不好吗?连接字符串中使用host=db
,因为db
是Docker Compose服务名称。
补充
它可以正常工作:
https://docs.docker.com/samples/library/postgres/#-or-via-psql
network_mode: host
吗? - Alejandro Galeradb
获取的FATAL
错误,(2)确保api
在db
准备就绪后尝试连接。 - tgogosports: - 5432:5432
添加到您的Docker Compose配置中,因为默认情况下所有端口都是关闭的。 - Dominic Barnes