cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to run cds deploy with PostgreSQL DB

0 Kudos

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": "***************"

}

}

}

}

}

Accepted Solutions (0)

Answers (2)

Answers (2)

gregorw
Active Contributor
0 Kudos

Have you followed the documentation:

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

?

UBrand251
Participant
0 Kudos

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.

0 Kudos

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