CAP PostgreSql setup local debugging using Docker ...
Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
This is the sequel of CAP PostgreSql, after your completion of your previous exercise (https://blogs.sap.com/2023/10/10/cap-with-postgresql-db-alternate-to-hana-cloud-db/) of bootstrapping up your CAP PostgresSQL, the next logical step is how to configure perform a local run using cds-watch and cds-serve to persist your data onto postgres db.
You should have the skeletal CAP project setup with postgres db.
Before we start the next exercise, you would need to have docker container install on your machine.
Step 2: In your terminal run the docker command to create the postgres db as an image
docker-compose -f pg.yml up -d
Step 3: Connect your DBeaver to confirm that your postgres db has been created successfully, ensure your postgres db container is active and running within your docker container. Your connectionstring for DBeaver should looks like something below.
Host
localhost
Database
postgres
Port
5432
Username
postgres
Password
postgres
Step 4: ensure your DBeaver is able to establish connection to your postgres db in docker.