Pool_size: 10 Two: Fix the postgres config to match up with Phoenix Show_sensitive_data_on_connection_error: true, Open config/dev.exs and change the config to have your username and a blank password.īy default Phoenix assumes “postgres” for the username and password. psql -version psql (PostgreSQL) 11.5 Start PostgreSQL To start PostgreSQL run the following command in the Terminal.
#Homebrew postgres install#
brew install postgres We can check the version of PostgreSQL using the psql command. One: Fix the Phoenix config to match up with homebrew In Terminal run the following command to install PostgreSQL on Mac using Homebrew. With that warning out of the way, here are the lines to blindly copy and paste into your terminal: brew uninstall postgres rm -rf /usr/local/var/postgres rm /usr/local/var/log/postgres.log rm -f /.psqlrc /. There’s a couple of ways to fix the problem. Postgres.app includes psql, a versatile command line client for PostgreSQL. We also have instructions for upgrading from older versions of Postgres.app. That’s not ideal! The core issue in that stack trace error is role "postgres" does not exist If you have previously installed PostgreSQL using homebrew, MacPorts, the EnterpriseDB installer, consider removing other PostgreSQL installations first. ** (Mix) The database for Hello.Repo couldn 't be created: killed (connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5 (db_connection 2.4.0) lib/db_connection/connection.ex:100: /2
If yes, then type this command to create the symlink: ln -sfv. ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist First, go to /usr/local/opt/postgresql/ using your terminal and verify that you have the file. If you’re trying to follow along the Elixir Phoenix Up and Running guide you may run straight into this error if you’re using homebrew’s Postgres install when you run mix ecto.create $ mix ecto.createġ8:54:52.762 GenServer #PID terminating
0 kommentar(er)
