Resize on HDD and RAM on Linux with Postgre SQL

[shubham6]

How to enbale the resize on Postgre SQL .

Current configurations.

vCPUs16 Memory104 GB SSD storage200 GB

Required

vCPUs32 Memory208 GB SSD storage2000 GB 

[ms4446]

To resize your Cloud SQL instance in Google Cloud, you can follow these steps:

1. Go to the Google Cloud Console: https://console.cloud.google.com/

2. Click on the hamburger menu (three horizontal lines) in the top left corner.

3. Navigate to "SQL" under the "Storage" section.

4. Click on the name of the instance that you want to resize.

5. Click on the "Edit" button at the top of the page.

6. Under the "Machine type and storage" section, you can adjust the number of vCPUs and the amount of memory. For your case, you should select a machine type with 32 vCPUs and 208 GB of memory.

7. In the "Storage" section, you can adjust the amount of SSD storage. For your case, you should enter 2000 GB.

8. Click on the "Save" button at the bottom of the page to apply your changes.

Please note that resizing an instance requires a restart of the instance, during which your instance will not be available. You should plan to resize during a maintenance window or a time when the disruption will have minimal impact on your users.