Question

Elixir, Ecto / Phoenix + Managed Postgres Db

Posted March 12, 2019 923 views
Docker

I’m trying to setup an Elixir / Phoenix / Ecto project on my droplet and connect to a DO managed postgresql. No matter what I do I can’t connect to my DB properly:

** (Postgrex.Error) FATAL 3D000 (invalidcatalogname) database “postgres” does not exist
(dbconnection) lib/dbconnection/connection.ex:84: DBConnection.Connection.connect/2
(connection) lib/connection.ex:622: Connection.enterconnect/5
(stdlib) proclib.erl:249: :proclib.initpdoapply/3

My connection string is right, connectivity seems fine ( I setup my droplet to be able to access the db cluster) but Elixir/Ecto complains with the above error.

Add a comment
giorgiog
By:
giorgiog
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer
bhogan March 13, 2019

HI! Sorry to hear you ran into a snag. I just set up a brand new Elixir/Phoenix app myself and ran into the exact same issue you had.

I did a little digging and it seems that either Ecto or Postgres expects the postgres database to exist.

I logged into the db directly with my doadmin user and looked around, and surely enough there’s no postgres database. So I created one:

CREATE DATABASE postgres WITH OWNER doadmin

Then I disconnected from the console, re-ran mix ecto.create and was greeted with:

The database for Hello.Repo has been created

I hope that helps move you forward!

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help