Question Re: Unable to run cds deploy with PostgreSQL DB in Technology Q&A

Unable to run cds deploy with PostgreSQL DB

akhthaaralibadhusha — Tue, 05 Dec 2023 12:51:24 GMT

Hi I have create an CAP application backed by PostgreSQL Database. When I do cds deploy --profile pg, it is giving the below error.

deployment to postgres-50b4fd02-0cbd-4da0-99aa-c4b4c5a74525.cqryblsdrbcs.us-east-1.rds.amazonaws.com:2732 failed

TimeoutError: ResourceRequest timed out

package.json

"cds": {

"requires": {

"db": {

"[pg]": {

"kind": "postgres",

"credentials": {

"host": "postgres-50b4fd02-0cbd-4da0-99a***********25.cqryblsdrbcs.us-east-1.rds.amazonaws.com",

"port": 2732,

"user": "**************",

"password": "************",

"database": "***************"

}

Re: Unable to run cds deploy with PostgreSQL DB

UBrand251 — Tue, 05 Dec 2023 13:10:56 GMT

Hi,

did you create the database (in your package.json --> "***********") in PostgreSQL DB? It is mandatory that you not only get the PostgreSQL DB server running and create the user/pwd defined in package.json in PostgreSQL, but you also need to create the database on the PostgreSQL server yourself. The tool pgAdmin4 offers a "Create Database" functionality. Just provide the name and user, and you should be fine.

Re: Unable to run cds deploy with PostgreSQL DB

akhthaaralibadhusha — Tue, 05 Dec 2023 15:29:11 GMT

But it has a database already created for me. Can't I use that.

And also I tried connecting to the PG, from pgadmin4 app, it is giving timeout error

Re: Unable to run cds deploy with PostgreSQL DB

gregorw — Tue, 05 Dec 2023 20:31:17 GMT

Have you followed the documentation:

https://cap.cloud.sap/docs/guides/databases-postgres

Re: Unable to run cds deploy with PostgreSQL DB

MoatazElbeshry — Wed, 23 Jul 2025 12:04:09 GMT

Actually I am facing the exact same issue, did you manage to solve it ?