Ability to use Postgres socket

[mahalel]

Hi, would it be possible to add support to connect to Postgres via unix socket please?

The DSN would be in this format for Pydantic v1: 'postgresql://derp@/databasename?host=/var/run/postgresql'
I believe this is valid in pydantic v2 postgresql://derp@%2Fvar%2Frun%2Fpostgresql/databasename

Reading db_providers.py I don't believe I can achieve this DSN at the moment.

Thank you for a great project!

[apiontek]

I would also like to be able to do this. I already do it for a few other containers, by creating a shared docker volume mount, and it works great.

[boc-the-git]

Are there any functional benefits to this, or is it simply a different way of providing the configuration?

[apiontek]

My understanding is that UNIX sockets can be much faster than TCP sockets¹²

That said, it turns out this already works if one sets POSTGRES_SERVER to the socket path. I figured I would try it because this same approach has worked for some other apps & containers. For example, for me I set POSTGRES_SERVER=/var/run/postgresql instead of providing a docker container name/alias. (For reference, my postgres & mealie containers share volume assignment: ./sock/pg15:/var/run/postgresql)

So the main thing missing would be a note in the documentation that a socket path can be set for that config value.

Footnotes

1. serverfault reference ↩

2. stackexchange reference ↩