Hi friends,

I am very new to Phoenix and PostgreSQL database. I am trying to deploy a simple very basic web app on fly.io to try to understand the deployment process so that I can adapt to my existing projects but I am very lost and confused. Here’s what I did.

mix phx.new Testing --app testing123

cd Testing

mix ecto.create

And then I used fly launch and fly deploy command. I got the following errors.

** (RuntimeError) environment variable DATABASE_URL is missing.
For example: ecto://USER:PASS@HOST/DATABASE

What I don’t understand here is the DATABASE_URL. How do I construct one?

When I do brew services list, I have postgresql@15 running already. If I do, psql testing123_dev and do \conninfo, I got "You are connected to database “testing123_dev” as user “sawwerakyawkyaw” via socket in “/tmp” at port “5432”.

Does that mean my DATABASE_URL is ecto://sawwerakyawkyaw:PASS@localhost:5432/testing123_dev?

Also, for each Phoenix project that I create, am I going to need unique DATABASE_URL for each one?

I am very lost and confused. If you can answer my questions or you know any resources to learn more about understanding postgres databases and/ or how to properly deploy, I would really appreciate it.

Many thanks.