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.

    • ForteanCum [comrade/them]
      ·
      1 year ago

      I think I forgot to mention, my scripts will probably mostly not be inside docker containers, is that an issue for which network type to select?

      • chickentendrils [any, comrade/them]
        ·
        1 year 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]
          ·
          1 year 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]
            ·
            1 year 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