# Set up Databases

Create 2 databases, care-db and metabase-db

1. SQL > Create instance > PostgreSQL ([link](https://console.cloud.google.com/sql/instances/create;engine=PostgreSQL))
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**&#x20;
   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**