HI, I am trying render for the first time. i created a small postgres database on render called “render” and a small nodejs app. They are in the same region. nodejs app on render seems to be able to connect the render database but seems to not be able to detect that the port 5432 is open.
what works: I can connect to the render postgres database using my local pgadmin and created a db table in render db.
what works: i can also use my nodejs app running on my local computer to connect to the render database so that when i enter data into my local nodejs app it goes into the render DB.
what does not work: when i run the nodejs app that i uploaded to render, i seems to be able to connect to the database as the database logs seem to indicate this however. it seems it cannot detect port 5432 as open. i cant figure out what the problem is between the nodejs app and postgres DB since the DB seems to accept the connection from the app. do u know what the issue is?
The attached pics: first one is of the error in nodejs and second one shows the db messages which seems to indicate that the nodejs app connected to the database.
