Connect to remote database question

[frenzzy]

As I see you are not using ports directive in docker-swarm.yml:

devops-directive-docker-course/12-deploying-containers/docker-swarm/docker-swarm.yml

Lines 65 to 80 in 9ff3c72

	db:
	image: postgres:15.1-alpine
	volumes:
	- pgdata:/var/lib/postgresql/data
	environment:
	- PGUSER=postgres
	- POSTGRES_PASSWORD_FILE=/run/secrets/postgres-passwd
	secrets:
	- postgres-passwd
	healthcheck:
	test: ["CMD-SHELL", "pg_isready"]
	interval: 10s
	timeout: 5s
	retries: 5
	networks:
	- backend

@sidpalas can you please share a knolage on how to connect the database to manage data from your comuter?

I tried to use the following instructions but without success:

• https://code.visualstudio.com/docs/containers/ssh
• https://guillim.github.io/ssh,/docker/2020/03/11/ssh-port-forwarding-with-docker.html

What I have tried locally:

cd 12-deploying-containers/docker-swarm
docker context create example --docker "host=ssh://root@example-app-server-ip:22"
docker context use example
docker stack deploy -c docker-swarm.yml example-app # deployed your example to VPS
docker ps # to get container id: 148cac4c4793
docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' 148cac4c4793 # to get container ip: 10.0.11.3
ssh -L 5432:10.0.11.3:5432 root@example-app-server-ip # connected to docker swarm server
psql --version # psql (PostgreSQL) 15.3 (Homebrew)
psql -h 127.0.0.1 -p 5432 -U postgres postgres

psql: error: connection to server at "127.0.0.1", port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

P.S.: Thank you for the tutorial, it is really helpful!