Error when trying to create database - Ecto - Phoenix

Question

I'm getting an error when trying to create a database. I have postgres installed and I've already made a few test projects successfully. And, I've not seen this error. Any help would be great:

ERROR:

 ~/Desktop/elixir/restore $ mix ecto.create
** (Mix) The database for Restore.Repo couldn't be created: tcp connect: connection refused - :econnrefused

21:52:23.978 [error] GenServer #PID<0.150.0> terminating
** (Postgrex.Error) tcp connect: connection refused - :econnrefused
    (db_connection) lib/db_connection/connection.ex:148: DBConnection.Connection.connect/2
    (connection) lib/connection.ex:623: Connection.enter_connect/5
    (stdlib) proc_lib.erl:240: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol

Answer 1

I had the same issue, and the problem was that postgres was not running.

so, to check this, you should run :

brew services list

and then, if you see :

Name Status User Plist postgresql stopped

you should run :

brew services start postgresql

cheers!

Answer 2

I had same problem today when tried to run mix ecto.create. So first make sure you have postgres. recommend using brew to install it.

brew install postgres

use brew services to start/stop postgresql,

create a database,

create postgres superuser,

probably you will need to give permission on folders.

these links were useful to me :

psql: FATAL: role "postgres" does not exist

psql: FATAL: database "<user>" does not exist