Pfthb

I'm currently having some some problems with docker and connecting a node project with postgres when running inside it. I use docker toolbox by the way since I don't have windows pro.

my docker-compose file looks like this

version: '3'
 services:
 db:
 image: postgres:latest
 ports:
 - "5432:5432"
 environment:
 POSTGRES_PASSWORD: 123456
 POSTGRES_USER: postgres
 POSTGRES_DB: dockerdb
 network_mode: bridge
 container_name: postgres
 volumes:
 - ./init.sql:/docker-entrypoint-initdb.d/init.sql

 web:
 build: .
 ports:
 - "5000:5000"
 - "3000:3000"
 depends_on:
 - db
 environment:
 DB_HOST: db

and my express server is just this, it's alittle bit of a mess at this time.

const Pool = require('pg')
var express = require('express');
var app = express;

const pool = new Pool(
 user: 'postgres',
 host: process.env.DB_HOST )

// the pool with emit an error on behalf of any idle clients
// it contains if a backend error or network partition happens
pool.on('error', (err, client) => 
 console.error('Unexpected error on idle client', err)
 process.exit(-1)
)

// callback - checkout a client
pool.connect((err, client, done) => 
 if (err) throw err
 client.query('SELECT * FROM users WHERE id = $1', [1], (err, res) => 
 done()

 if (err) 
 console.log(err.stack)
 else 
 console.log(res.rows[0])
 
 )
)

When I run it in docker, the containers run, I can access postgress db through the terminal and interact with with like creating and inserting things like that, but my node program doesn't seem to connect with it since I don't get any of the console log, I don't know if that is because of a connection problem or just because of some noobie mistakes, can some please help me. By the way I have created a table called users in my init.sql file and given it data, data I been able to access from the docker terminal using the psql command.

here is a picture of what's happening inside docker.
enter image description here

That happens because the db takes some time to start and with your docker compose your server and db start at the same time. So you need some delay on the server to let the DB starts. I have an example in github that you can download and test https://github.com/PedroS11/node-postgres-redis-docker. Check my docker-compose file where you can see I have a script wait-for-it. This script has a sleep so that the server only starts 15s after the database.