Question Re: Developing locally with PostgreSQL BTP Instance in Technology Q&A

Developing locally with PostgreSQL BTP Instance

jorrevynckier — Thu, 29 Aug 2024 14:11:11 GMT

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!

Re: Developing locally with PostgreSQL BTP Instance

gregorw — Thu, 29 Aug 2024 20:43:29 GMT

To be not blocked in developing I would suggest you use a PostgreSQL docker container during development. Check https://github.com/gregorwolf/pg-beershop and https://github.com/cap-js/cds-dbs/tree/main/postgres for samples.

Re: Developing locally with PostgreSQL BTP Instance

Dinu — Fri, 30 Aug 2024 10:46:17 GMT

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"

Re: Developing locally with PostgreSQL BTP Instance

jorrevynckier — Fri, 30 Aug 2024 11:53:40 GMT

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

Re: Developing locally with PostgreSQL BTP Instance

jorrevynckier — Fri, 30 Aug 2024 11:55:41 GMT

Thanks for the suggestion gregor! I was going to try this, but since Dinu found the solution, I will keep this for a future reference.

Re: Developing locally with PostgreSQL BTP Instance

gregorw — Fri, 30 Aug 2024 12:34:40 GMT

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?