will/crystal-pg

Connecting to unix socket with url

tleydxdy opened this issue · 3 comments

tleydxdy commented

I tried various forms such as

postgres://user:pass@/dbname
postgres://user:pass@/dbname?host=/var/run/postgresql
postgres://user:pass@%2Fvar%2Frun%2Fpostgresql/dbname

but they all doesn't seem to work

will commented

Hm, it might not be currently possible with a url.

The relevant code is here: https://github.com/will/crystal-pg/blob/master/src/pq/conninfo.cr#L52

This will use a socket if the host parameter starts with a / character. However the crystal stdlib URI.parse might make it impossible to get a host starting with that. I'm unsure what can be done about this.

As an alternative, you should be able to do "host=/var/run/postgresql user=user password=password" or with a bit more effort construct a PQ::ConnInfo directly.

tleydxdy commented

yeah, I'm using someone else's code, I will see what I can do.

tleydxdy commented

aha, postgres://user:pass@/dbname?host=/var/run/postgresql worked, I just made some silly mistake. :(

  • 👍1