Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Discourse Setup Error - Easy setup is not so easy? Question Question
I know it is obvious but after a Windows installation - how do I use Docker? Question Question

Question

Elixir, Ecto / Phoenix + Managed Postgres Db

Posted March 12, 2019 2.5k 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Discourse Setup Error - Easy setup is not so easy? Question Question
I know it is obvious but after a Windows installation - how do I use Docker? Question Question

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.

×
Submit an Answer
2 answers
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
stanislavgenchev December 29, 2020

Ecto uses the ‘maintenance_database’ property to set the name of the database to connect to when creating or dropping the database. By default it’s “postgres”.
In DigitalOcean, when a cluster is created, the default database is called “defaultdb”.
So all you need to do is add the following config:

# Configure your database
config :elixir_app, ElixirApp.Repo,
  ...
  database: "elixir_app_dev",
  maintenance_database: "defaultdb",
  ...

Here is the documentation:
https://hexdocs.pm/ecto_sql/Ecto.Adapters.Postgres.html

Reply Report

Related

Looking for something else?

Ask a new question Search for more help