Rails PostgreSQL socket path

Question

Suppose that I have a Postgres cluster running, with its Unix domain socket located under /some/custom/path

How do I set up my database.yml so that the Rails app can connect to the cluster?

Dave Slutzkin · Accepted Answer · 2014-11-20 10:12:39Z

11

From the postgres docs:

host: Name of host to connect to. If this begins with a slash, it specifies Unix-domain communication rather than TCP/IP communication; the value is the name of the directory in which the socket file is stored.

The ActiveRecord adapter just passes through the host parameter so it's as simple as just putting this line in your database.yml:

host: /path/to/socket/file

answered Nov 20, 2014 at 10:12

Dave Slutzkin

1,63215 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dave Slutzkin Over a year ago

@MrMobster It's actually really unclear in the ActiveRecord docs and in the docs for the PG gem that combined they provide little more than a thin Ruby wrapper around libpq. I banged my head against this exact issue for a couple of hours once!

Collectives™ on Stack Overflow

Rails PostgreSQL socket path

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related