Search code examples
postgresqlelixirphoenix-frameworkecto

Error when trying to create database - Ecto - Phoenix

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
Solution

  • 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