There is no local postgres running / no local pg_hba.conf
Here is ecto config
config :myapp, Myapp.Repo, adapter: Ecto.Adapters.Postgres, url: "postgres://user:pwd@pg_instance.elephantsql.com/db", pool_size: 10
mix ecto.create is throwing this error.
** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) no pg_hba.conf entry for host "router_public_ip", user "user", database "postgres", SSL off
- It’s for some reason reading router_public_ip and not ip of pg_instance.elephantsql.com. Setting IP manually in config doesn’t help.
- It’s reading the user correctly. But database is “postgres” instead of “db” (as mentioned in url)
What can be done?