Developing locally with PostgreSQL BTP Instance

[jorrevynckier]

Hi,

I am trying to run my application locally with data from a deployed BTP PostgreSQL instance. I am successful in running an SSH tunnel and connecting to the DB via DBeaver.

However when I adjust the settings in my CAP Application, I do see during startup that the settings are taken into account correctly.

However when the application is launched I get an immediate 'Timeout'.

Would anyone be able to assist me? 

Thanks! 

[Dinu · Accepted solution]

Set host as 127.0.0.1; localhost does not work in this case when ip6 stack is present.

Also, you need to insist on SSL. So, you have to either provide ssl configurations from the credentials of the service

ssl: {
        ca: pg_cred.sslrootcert,
        servername: pg_cred.hostname
    }

or do not verify SSL certificates with :

ssl: { rejectUnauthorized: false }

or set environment variables:

NODE_TLS_REJECT_UNAUTHORIZED="0"
PGSSLMODE="require"

[jorrevynckier · Accepted solution]

I just added the environment variables and it worked! Thanks!

[gregorw · Accepted solution]

Can you please check if this informaiton is available at https://github.com/cap-js/cds-dbs/tree/main/postgres and if not contribute it?