Docker Compose + Spring Boot + Postgres 连接 [英] Docker Compose + Spring Boot + Postgres connection
问题描述
我有一个与 Postgres 数据库配合使用的 Java Spring Boot 应用程序.我想对它们都使用 Docker.我最初只将 Postgres 放在 Docker 中,并且我有一个 docker-compose.yml
文件定义如下:
I have a Java Spring Boot app which works with a Postgres database. I want to use Docker for both of them. I initially put just the Postgres in Docker, and I had a docker-compose.yml
file defined like this:
version: '2'
services:
db:
container_name: sample_db
image: postgres:9.5
volumes:
- sample_db:/var/lib/postgresql/data
environment:
- POSTGRES_PASSWORD=sample
- POSTGRES_USER=sample
- POSTGRES_DB=sample
- PGDATA=/var/lib/postgresql/data/pgdata
ports:
- 5432:5432
volumes:
sample_db: {}
然后,当我发出命令 sudo dockerd
和 sudo docker-compose -f docker-compose.yml up
时,它正在启动数据库.我可以使用 pgAdmin
进行连接,例如,使用 localhost
作为服务器和端口 5432
.然后,在我的 Spring Boot 应用程序中,在 application.properties
文件中,我定义了以下属性.
Then, when I issued the commands sudo dockerd
and sudo docker-compose -f docker-compose.yml up
, it was starting the database. I could connect using pgAdmin
for example, by using localhost
as server and port 5432
. Then, in my Spring Boot app, inside the application.properties
file I defined the following properties.
spring.datasource.url=jdbc:postgresql://localhost:5432/sample
spring.datasource.username=sample
spring.datasource.password=sample
spring.jpa.generate-ddl=true
此时我可以通过 Spring Suite 在本地运行我的 Spring Boot 应用程序,并且一切正常.然后,我还想将我的 Spring Boot 应用程序添加为 Docker 映像.我首先在我的项目目录中创建了一个 Dockerfile,如下所示:
At this point I could run my Spring Boot app locally through Spring Suite, and it all was working fine. Then, I wanted to also add my Spring Boot app as Docker image. I first of all created a Dockerfile in my project directory, which looks like this:
FROM java:8
EXPOSE 8080
ADD /target/manager.jar manager.jar
ENTRYPOINT ["java","-jar","manager.jar"]
然后,我进入到发出mvn clean
的项目目录,接着是mvn install
.接下来,发出 docker build -f Dockerfile -t manager .
后跟 docker tag 9c6b1e3f1d5e myuser/manager:latest
(id 正确).最后,我将现有的 docker-compose.yml
文件编辑为如下所示:
Then, I entered to the directory of the project issued mvn clean
followed by mvn install
. Next, issued docker build -f Dockerfile -t manager .
followed by docker tag 9c6b1e3f1d5e myuser/manager:latest
(the id is correct). Finally, I edited my existing docker-compose.yml
file to look like this:
version: '2'
services:
web:
image: myuser/manager:latest
ports:
- 8080:8080
depends_on:
- db
db:
container_name: sample_db
image: postgres:9.5
volumes:
- sample_db:/var/lib/postgresql/data
environment:
- POSTGRES_PASSWORD=sample
- POSTGRES_USER=sample
- POSTGRES_DB=sample
- PGDATA=/var/lib/postgresql/data/pgdata
ports:
- 5432:5432
volumes:
sample_db: {}
但是,现在如果我发出 sudo docker-compose -f docker-compose.yml up
命令,数据库将再次正确启动,但我收到错误并退出 Web 应用程序部分的代码 1.问题是连接字符串.我相信我必须将其更改为其他内容,但我不知道应该是什么.我收到以下错误消息:
But, now if I issue sudo docker-compose -f docker-compose.yml up
command, the database again starts correctly, but I get errors and exit code 1 for the web app part. The problem is the connection string. I believe I have to change it to something else, but I don't know what it should be. I get the following error messages:
web_1 | 2017-06-27 22:11:54.418 ERROR 1 --- [ main] o.a.tomcat.jdbc.pool.ConnectionPool : Unable to create initial connections of pool.
web_1 |
web_1 | org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
有什么想法吗?
推荐答案
每个容器都有自己的网络接口和自己的本地主机.所以改变 Java 指向 Postgres 的方式:
Each container has its own network interface with its own localhost. So change how Java points to Postgres:
spring.datasource.url=jdbc:postgresql://localhost:5432/sample
收件人:
spring.datasource.url=jdbc:postgresql://db:5432/sample
db
将解析为正确的 Postgres IP.
db
will resolve to the proper Postgres IP.
奖金.使用 docker-compose,您无需手动构建图像.所以改变:
Bonus. With docker-compose you don't need to build your image by hand. So change:
web:
image: myuser/manager:latest
收件人:
web:
build: .
这篇关于Docker Compose + Spring Boot + Postgres 连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!