A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://github.com/phoenixframework/phoenix/issues/1624 below:

create database - mix ecto.create

### Environment

### Expected behavior

$ mix ecto.create
The database for HelloPhoenix.Repo has been created.

### Actual behavior

//when I tried to create database, I received this error:

[root@centos66a hello_phoenix]# mix ecto.create

** (Mix) The database for HelloPhoenix.Repo couldn't be created, reason given: psql: FATAL: Ident authentication

failed for user "postgres"

//There is troublesooting that can fix this by creating the "postgres" role with the permissions needed to log in and

create a database.

=# CREATE ROLE postgres LOGIN CREATEDB;
CREATE ROLE

//but when I entered , I received this error:

postgres-# CREATE ROLE postgres LOGIN CREATEDB;
ERROR: syntax error at or near "su"
LINE 1: su - postgres
^

//but I found that postgres role already exist:

postgres-# pg_roles;
rolname

postgres
(1 row)

// after config/dev.exs set watchers to empty:
watchers: []

error changed:
[root@centos66a config]# mix ecto.create
** (Mix) The task "ecto.create" could not be found


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4