Set up Databases

Create 2 databases, care-db and metabase-db

1. SQL > Create instance > PostgreSQL (link)

2. Create instance for care:

   1. Instance ID: care-db

   2. Password: <use your own strong password>

   3. Database version: PostgreSQL 14

   4. Cloud SQL edition: Enterprise

   5. Region: asia-south1

   6. Zonal availability: Single zone

   7. Click show zones

   8. Primary zone: asia-south1-a

   9. Click show configurations

   10. Machine configuration: Dedicated core (2 vCPU, 8 GB)

   11. Storage type: SSD

   12. Storage capacity: 20 GB

   13. Enable automatic storage increases: Enabled

   14. Under connections, set

   15. Instance IP assignment: Private IP

       1. Associated networking: care-vpc

       2. If not presented with setup connection dialog, skip to p

       3. Select SET UP CONNECTION for setting up a private service connection and Click ENABLE API

       4. Select Use an automatically allocated IP range

       5. Click create connection

   16. Public IP: Disabled

   17. Under Data protection

   18. Automated backups: Enabled

   19. automated backup window: 2:30 AM - 6:30 AM

   20. Enable point-in-time recovery: Enabled

   21. Days of logs: 7

   22. Enable deletion protection: Enabled

   23. Maintenance window: Sunday

   24. Once the db instance is initialized, create a new database:

       1. Click on care-db > Databases > create database

       2. Enter the db name care

       3. Click create

Repeate the above steps for metabase-db with the following changes

1. Instance name: metabase-db

2. Machine configuration: Dedicated core (1 vCPU, 3.75 GB)

3. db name: metabase