How to connect to a postgres container from another server?

Question

PostgreSQL

the container with postgres is spinning on the same server with the following compos file:

version: "2"
services:
    db:
        image: "postgres:11-alpine"
        container_name: db
        restart: always
        ports:
            - 127.0.0.1:${POSTGRES_PORT}:5432
        environment:
            - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
            - POSTGRES_USER=${POSTGRES_USER}
        volumes:
            - postgres-volume:/var/lib/postgresql/data

volumes:
    postgres-volume:

How can I connect to this database from another server?

Answer 1

Change the port directives so that the container is not bound to the localhost, but to the external