ECONNREFUSED for Postgres on nodeJS with dockers

by

Your DATABASE_URL refers to 127.0.0.1, which is the loopback adapter (more here). This means “connect to myself”.

When running both applications (without using Docker) on the same host, they are both addressable on the same adapter (also known as localhost).

When running both applications in containers they are not both on localhost as before. Instead you need to point the web container to the db container’s IP address on the docker0 adapter – which docker-compose sets for you.

Change:

127.0.0.1 to CONTAINER_NAME (e.g. db)

Example:

DATABASE_URL: postgres://username:[email protected]:5432/mydatabase

to

DATABASE_URL: postgres://username:pgpassword@db:5432/mydatabase

This works thanks to Docker links: the web container has a file (/etc/hosts) with a db entry pointing to the IP that the db container is on. This is the first place a system (in this case, the container) will look when trying to resolve hostnames.

More Related Contents:

  1. Docker – SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306
  2. Docker-compose: node_modules not present in a volume after npm install succeeds
  3. How can I see the SQL generated by Sequelize.js?
  4. How to implement many to many association in sequelize
  5. MongoDB on with Docker “failed to connect to server [localhost:27017] on first connect “
  6. How to set npm credentials using `npm login` without reading from stdin?
  7. Use docker run command to pass arguments to CMD in Dockerfile
  8. Error: Redis connection to 127.0.0.1:6379 failed – connect ECONNREFUSED 127.0.0.1:6379
  9. Why does `package-lock.json` causes a failure in a docker container build when `npm install`?
  10. Why COPY package*.json ./ precedes COPY . .?
  11. PostgreSQL multi-row updates in Node.js
  12. How to install nvm in docker?
  13. How to cache the RUN npm install instruction when docker build a Dockerfile
  14. Setting all queries to raw = true sequelize
  15. NodeJS require a global module/package
  16. How to make node.js require absolute? (instead of relative)
  17. Difference between app.use and app.get in express.js
  18. Mongoose, update values in array of objects
  19. How, in general, does Node.js handle 10,000 concurrent requests?
  20. Firebase cloud functions is very slow
  21. MongoDB/Mongoose querying at a specific date?
  22. How to persist data in a dockerized postgres database using volumes
  23. CRUD blueprint overriding in sails.js
  24. MongooseError – Operation `users.findOne()` buffering timed out after 10000ms
  25. Microsoft Bot framework: Sending Message on connect
  26. npm install -g less does not work: EACCES: permission denied
  27. Mongoose nested query on Model by field of its referenced model
  28. Node Sass does not yet support your current environment: Windows 64-bit with Unsupported runtime (88)
  29. ENOENT: no such file or directory .?
  30. How to get SCSS variables into react

Leave a Comment