How can I connect to postgres via a unix socket?

[cameron-martin]

Is this possible? If so, what format does the DSN have to be in to do this?

Edit: After a bit of investigation, I've found a relevant issue.

[zepatrik]

I guess you answered the question yourself, we just pass the DSN on to pop.

[zepatrik]

Probably still the same URL parsing issue in pop then. I assume that if they would pass it on correctly, the driver would handle it.

[aeneasr]

Are you sue that the path to the socket is correct? Aren't they usually in /var/run/postgresql? It explicitly states connect: no such file or directory

[cameron-martin]

Cloud run mounts it at /cloudsql/<instance_connection_name>. I don't know where it's getting /tmp/.s.PGSQL.5432 from. Maybe that's what it defaults to?

[aeneasr]

What DSN did you use?

[cameron-martin]

Unfortunately I removed the DSN from the secrets store immediately after I tested it. If I get around to trying it again I'll post it here, but it's not a priority for me right now.