I'm trying out a home server with debian installed. I've also installed https://yacht.sh/docs/Pages/Applications and am now going to make a postgres docker. I'm not familiar with yacht.sh I'm just trying it out. But I want a docker postgres server for my random scripts to connect to. For that purpose, which network mode would be best for this? I'm generally familiar with docker in an amateur sense, this is just a hole in my knowledge.

I'm reserving a native debian install of postgres for a different purpose.

I'm open to unrelated suggestions about what to install on my new home server. Samba is already installed, Jellyfin is next after this.

  • chickentendrils [any, comrade/them]
    ·
    2 years ago

    As long as you define a port for the container (not familiar with yacht, but eg add a ports section to the compose file) the DB engine will be reachable on localhost at that port.

    Eg for postgres' default ports.

     ports:
        - "5432:5432"
    

    If there's no firewall on the docker daemon host, and no IP range restrictions in postgres' configuration, this would also be reachable from other machines on your local network.

    • Sphere [he/him, they/them]
      ·
      edit-2
      2 years ago

      My understanding is that what you're describing does not work when a container is in bridge network mode; in my experience the behavior you're talking about requires that a container be in host network mode.

      • chickentendrils [any, comrade/them]
        ·
        edit-2
        2 years ago

        Seems OK in bridge mode, though I am running a few months behind latest for docker itself

        https://hexbear.net/pictrs/image/AEj1GMKo5E.png

        I use podman in prod and docker locally since podman wasn't playing nice with WSL