为什么Phoenix(ecto/Postgresx)在dev中无法连接

问题描述

我正在开始Elixir/Phoenix之旅，并且我的postgres连接遇到了一些麻烦.

I am beginning my Elixir/Phoenix journey and having some trouble with my postgres connection.

启动服务器时，我得到:

When I start up my server I get:

 $ mix phoenix.server
 [error] Postgrex.Protocol (#PID<0.214.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.217.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.218.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.211.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.215.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.219.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.216.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.213.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.212.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [error] Postgrex.Protocol (#PID<0.210.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused
 [info] Running Rumbl.Endpoint with Cowboy using http://localhost:4000
 [error] Postgrex.Protocol (#PID<0.215.0>) failed to connect: ** (Postgrex.Error) tcp connect: connection refused - :econnrefused

是Elixir，Phoenix和Ecto的新手，我不清楚如何调试此问题.关于我的问题是什么或我将如何进行调试的任何建议，将不胜感激.

Being new to Elixir, Phoenix, and Ecto I am unclear how to debug this problem. Any suggestions as to what my problem is or how I might go about debugging it would be much appreciated.

我的应用已设置

我有一个基本的应用程序

I have a basic app

mix phoenix.new rumbl
cd rumbl
mix deps.get
mix deps.compile

我的config/dev.exs具有以下数据库设置

My config/dev.exs has the following db setup

# Configure your database
config :rumbl, Rumbl.Repo,
  adapter: Ecto.Adapters.Postgres,
  username: "elixir",
  database: "rumbl_dev",
  hostname: "localhost",
  pool_size: 10

运行mix ecto.create时没有错误，并且在psql中运行\l时可以看到rumbl_dev.它也属于长生不老药用户.

When I run mix ecto.create there are no errors and I can see the rumbl_dev when I run \l in psql. It is owned by the elixir user too.

运行mix ecto.migrate会引发相同的连接错误

Running mix ecto.migrate throws the same connections errors

我的pg_hba.conf文件具有以下内容

My pg_hba.conf file has the following

local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

这是我使用psql登录时看到的内容

Here is what I see when I log in with psql

$ psql --dbname=rumbl_dev --username=elixir --host=127.0.0.1 --password
Password for user elixir:
psql (9.4.5)
Type "help" for help.

rumbl_dev=>

推荐答案

好，所以我知道了.最后，这是我的一个简单错误.虽然很容易制作.

Ok, so I figured it out. It is a simple mistake on my part in the end. Though an easy one to make.

我在Mac上使用Boxen，由于某种原因，它将端口更改为15432.

I am using Boxen on my Mac and it changes the port to 15432 for some reason.

如果mix ecto.create失败，我可能会早点降落.不确定为什么行得通.

I may have landed on this sooner if the mix ecto.create had failed. Not sure why that works.

希望这会在将来对其他人有所帮助

Hopefully this will help others in the future

这篇关于为什么Phoenix(ecto/Postgresx)在dev中无法连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！