Ecto postgrex and unix sockets for Phoenix

lpvm · October 9, 2018, 2:57pm

I’m trying to connect to Postgresql using unix sockets, but can’t find documentation or examples on how to do it.
postgrex already has support for unix sockets.

It seems that I could place some configuration such as
config :postgrex, socket_dir: "/var/run/postgres (maybe it’s wrong) in config/config.exs, but would need (I think) to change Ecto as well.

How to do this?

sribe · October 9, 2018, 5:14pm

I think you do it by passing in the path to the directory as the host name???

hackerboos · October 10, 2018, 4:07pm

This code suggests that the directory is all you need:

github.com

dillonhafer/budgetalex/blob/94ea14afe2c1d4c0e0f31c98251a70d06c12a26e/config/dev.exs#L50-L56


# Configure your database
config :budgetalex, Budgetalex.Repo,
  adapter: Ecto.Adapters.Postgres,
  database: "budgetalex_dev",
  socket_dir: "/var/run/postgresql",
  parameters: [application_name: "Budgetal Ex", statement_timeout: "5000"],
  pool_size: 10

lpvm · October 10, 2018, 9:29pm

José Valim answered in https://github.com/elixir-ecto/postgrex/issues/415#issuecomment-428625362
similar to @hackerboos answer.

Thank you for your help @hackerboos and @scribe

shahryarjb · January 16, 2022, 11:36pm

I set this, but I have this error in github ci

** (DBConnection.ConnectionError) tcp connect (/var/run/postgresql/.s.PGSQL.5432): no such file or directory - :enoent

Do you have any suggestion?

al2o3cr · January 17, 2022, 5:15am

A general forum etiquette suggestion: don’t go to 3+ year-old threads and re-ask a question that has a current thread. And if you do, at least link the current discussion