mbski

mbski

Hello,

I am coming back to Elixir world after one year and I wanted to learn also new stuff so I decided to use Docker to my development.

I pulled pgadmin4 and postgresql, set it up according to documentation/articles. It looks like it works fine. I can log in into pgadmin4 through docker, I can open server with credentials given for postgresql container.

Elixir works fine if I want to play with localhost - I have also desktop version of PGAdmin4 and if I use credentials and localhost I can easily create ecto database.

Problem starts when I want to use locally developed Elixir/Phoenix app with PostgreSQL which is in container. I couldn’t find anything that could have helped me resolved this.

Container name: postgres_db,
Username: postgres,
Password: admin123,
Image: postgres

dev.exs

config :weather, Weather.Repo,
  username: "postgres",
  password: "postgres",
  hostname: "postgres_db",
  port: 5432,
  database: "weather_dev",
  stacktrace: true,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10

Rest left unchanged from initially created files.

PS F:\weather> mix ecto.create
Compiling 28 files (.ex)
Generated weather app

08:05:39.563 [error] Postgrex.Protocol (pid<0.416.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (postgres_db:5432): non-existing domain - :nxdomain
** (Mix) The database for Weather.Repo couldn’t be created: connection not available and request was dropped from queue after 2000ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

  1. Ensuring your database is available and that you can connect to it
  2. Tracking down slow queries and making sure they are running fast enough
  3. Increasing the pool_size (although this increases resource consumption)
  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval

See DBConnection.start_link/2 for more information

Thats what i got when i try to create database.

I also tried to use IP address that I put while creating server in postgres, but it still times out.

My another try was also using docker-compose.yml

version: '3.8'

services:
  postgres_db:
    image: postgres
    volumes:
      - /var/lib/postgresql/data
    container_name: weather
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: weather_dev
    ports:
      - 5432:5432

Accordingly I updated dev.exs to fit those variables and stopped container created meanually (to omit port conflicts). Effect remains the same. Its not possible to connect Elixir with dockerized Postgres and I cant create database for my app.

Thanks for any help :wink:

Showing Posts 1 to 10

gmile

gmile

In short, in config/dev.exs change postgres_db hostname to localhost and try again - it should work:

diff --git a/config.exs b/config.exs
--- a/config.exs
+++ b/config.exs
@@ -3,3 +3,3 @@ config :weather, Weather.Repo,
   password: "postgres",
-  hostname: "postgres_db",
+  hostname: "localhost",
   port: 5432,
mbski

mbski OP

Actually it works for local instance of postgres but not for postgres container in docker.
I set password provided during setting up contaner, as a host (according to docs) i set up container name.

I get errors about non-existing domain.

With local Postgres everything works
With Postgres in docker I cant create database using mix ecto.create.

D4no0

D4no0

Is your elixir container part of that docker-compose too? If yes your configuration should work, otherwise you need to specify a custom network, as only containers from the same docker-compose are part of the same network automatically.

mbski

mbski OP

Actually I didnt put Elixir into container as I didn’t do anything in app. Just started and wanted to connect everything together and even meant to work with app development in container.

I meant to work directly from Windows with developing app but having it connected to containerized database. As it’s first time using docker and learning it I dont get whole concepts yet and how it should be resolved.

D4no0

D4no0

If your elixir application is not in container, then the only way is to expose the port and connect on localhost, just as it was mentioned previously by others.

mbski

mbski OP

I read a little about that but it still doesn’t work.
To create container and expose port I used command:

docker run --name postgres_db -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgres

Using those credentials and IPHost provided while inspecting container I could go into server in pgadmin4. Basically it works.

Now the part that doesn’t work with Elixir
dev.exs

config :weather, Weather.Repo,
  username: "postgres",
  password: "postgres",
  hostname: "postgres_db",
  port: 5432,
  database: "weather_dev",
  stacktrace: true,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10

As you can see. Credentials are the same. Hostname is container name in this case:
Obviously i got:

14:13:27.670 [error] Postgrex.Protocol (pid<0.211.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (postgres_db:5432): non-existing domain - :nxdomain

I changed hostname to localhost:

FORMATTER ERROR: bad return value

14:14:18.846 [debug] ** (RuntimeError) bad return value from Logger formatter Logger.Formatter, got [[<<179, 101, 109, 32, 110, 105, 101, 32, 112, 111, 119, 105, 111, 100, 179, 97, 32, 115, 105, 234, 32, 100, 108, 97, 32, 117, 191, 121, 116, 107, 111, 119, 110, 105, 107, 97, 32, 34, 112, 111, 115, 116, 103, 114, 101, 115, 34>>, “\n”] | “\e[0m”] after “\e[31m\n14:14:18.843 [error] Postgrex.Protocol (pid<0.416.0>) failed to connect: ** (Postgrex.Error) KATASTROFALNY 28P01 (invalid_password) autoryzacja has”
(kernel 9.0.2) logger_h_common.erl:430: :logger_h_common.string_to_binary/1
(kernel 9.0.2) logger_h_common.erl:396: :logger_h_common.do_log_to_binary/2
(kernel 9.0.2) logger_h_common.erl:177: :logger_h_common.log/2
(kernel 9.0.2) logger_backend.erl:51: :logger_backend.call_handlers/3
(db_connection 2.6.0) lib/db_connection/connection.ex:110: DBConnection.Connection.handle_event/4
(stdlib 5.0.2) gen_statem.erl:1379: :gen_statem.loop_state_callback/11
(stdlib 5.0.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

FORMATTER ERROR: bad return value

14:14:18.881 [debug] ** (RuntimeError) bad return value from Logger formatter Logger.Formatter, got [[<<179, 101, 109, 32, 110, 105, 101, 32, 112, 111, 119, 105, 111, 100, 179, 97, 32, 115, 105, 234, 32, 100, 108, 97, 32, 117, 191, 121, 116, 107, 111, 119, 110, 105, 107, 97, 32, 34, 112, 111, 115, 116, 103, 114, 101, 115, 34>>, “\n”] | “\e[0m”] after “\e[31m\n14:14:18.881 [error] Postgrex.Protocol (pid<0.424.0>) failed to connect: ** (Postgrex.Error) KATASTROFALNY 28P01 (invalid_password) autoryzacja has”
(kernel 9.0.2) logger_h_common.erl:430: :logger_h_common.string_to_binary/1
(kernel 9.0.2) logger_h_common.erl:396: :logger_h_common.do_log_to_binary/2
(kernel 9.0.2) logger_h_common.erl:177: :logger_h_common.log/2
(kernel 9.0.2) logger_backend.erl:51: :logger_backend.call_handlers/3
(db_connection 2.6.0) lib/db_connection/connection.ex:110: DBConnection.Connection.handle_event/4
(stdlib 5.0.2) gen_statem.erl:1379: :gen_statem.loop_state_callback/11
(stdlib 5.0.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

** (Mix) The database for Weather.Repo couldn’t be created: killed

Error is different - result the same. No connection.
It looks like it tries to go into my local instance of postgres but there are invalid credentials for that.
I dont know how it’s supposed to be working with localhost if its signed to local machine and not docker even if i exposed port and it should be working.

I am out of ideas for a now.

Tyson

Tyson

Most common cause of mismatched credentials when trying to connect to PG in container is that you still have PG running on the host system and are actually connecting to that. Either shut down PG on the host and restart the container, or bind the container port to something other than 5432 (and then configure Ecto to use the new port).

mbski

mbski OP

And that post with addition of advices above are solutions. I had of course closed Postgres but in the background there were left some tasks. I had to kill them and then Elixir created db and schemas. Perfect.

Other port didnt work by the way, but probably because I hadn’t it opened.

Big thanks for fast reply for silly questions :smiley:

Natanaelfelixx

Natanaelfelixx

Don’t know if you’ve fixed the problem, but in my case, i have the same problem using a postgres container with ruby, and i ran a container with this command:

docker run --network localhost --name postgres_db -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgres

just added --network localhost and used localhost on your config file and it should work

adamu

adamu

For local development I like to use this compose file as a template, which works well with an out of the box phoenix project.

services:
  postgres:
    image: postgres:17
    container_name: postgres
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
    volumes:
      - type: volume
        source: data
        target: /var/lib/postgresql/data
    ports:
      - name: postgres
        target: 5432
        published: 5432

volumes:
  data:
— All posts loaded —

Where Next? Top

Trending in Questions Top

Hellowman
Hello everyone! I am new to coding with Elixir/Erlang. And i am looking for some utilities for fuzzing testing like AFL++. Does anyone ...
New
yarrichar
I’m very new to Elixir, so sorry if this is a silly question: I am wondering what happens to the mailbox of a process when the machine i...
New
pragdave
How do I tell Hologram not to escape HTML when substituting into templates? {Textile.render(@product.long_description)} escapes the HTM...
New
mandar1045
I load tested a plain Phoenix chat app backed by Postgres with 100 million messages in it, everything on default settings, to see what br...
New
Fl4m3Ph03n1x
Background When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error: * assembling mark...
New
rlipscombe
I’d like to create a file with 600 permissions (rw-------), but there’s a race condition if I create it and then change the permissions. ...
New
saleyn
Is there a way to import record definitions in the iex shell for pretty printing (similar to the rr command in the erl shell)? This woul...
New

Other Trending Topics Top

GenericJam
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
261 13183 112
New
mudasobwa
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
OndrejValenta
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly) AI dream has many faces, but general...
New
kip
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews