ECONNREFUSED with Postgres, what is wrong with my addresses?

I have a cloud server (ubuntu 18.04) with NodeJS, postgresql, sequelize. My server starts, but cant connect to DB, i get
Error: connect ECONNREFUSED 192.168.0.2:5432

If i run ss -tl

[tcp] (https://i.stack.imgur.com/YQV6s.png)

and here is the sequilize.js

export default new Sequelize(
    process.env.DB_NAME, 
    process.env.DB_USER, 
    process.env.DB_PASS, 
    {
        dialect: 'postgres',
        host: "127.0.0.1",
        port: 5432,
        define: {
            underscored: true
        },
        logging: false,
        timezone: 'Europe',
    }
)

I am new to linux, sorry, got confused. I tried to switch host in sequilize to 192.168.0.2, the error is the same. How do i fix this?

In cases like this it's always good to try to connect with some tool that is known to work to make sure that you can indeed reach that porn on that IP from your host, and that the database server responds and works.

For Postgres, there is a command line tool called psql that you can use:

psql -h 127.0.0.1 -p 5432 -U $DB_USER $DB_NAME

You can use any other CLI or GUI tool that can connect to Postgres, but make sure that it is run locally on the same host as your Node app is running.

If you cannot connect in that way, then your Node app would not connect as well.

As freakish already noticed in the comments, your database may not accept connections from localhost. If you verify that this is the case, check the configuration, in particular: listen_addresses

See the documentation:

• https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-LISTEN-ADDRESSES