Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Notable to connect to cloudsql

I have a postgres server in cloud sql ,every thing was well working ,the database was not been used much so i decreased the cpu and ram to  vCPUs :-1 ,Memory :-3.75 ,GBSSD storage:- 4.67 TB. I dont have google support . I am not able to do anything with the db neither stop,restart or any activity.what should I do next please suggest

0 1 137
1 REPLY 1

I'm sorry to hear about the issue you're facing with your PostgreSQL server on Google Cloud SQL.

Here are some general suggestions that might help you resolve the issue:

  1. Check the Logs: Look at the logs in the Google Cloud Console to see if there are any error messages or warnings that might indicate what's wrong.

  2. Try the gcloud Command-Line Tool: If the web console is not responsive, you might have better luck using the gcloud command-line tool. You can use commands like gcloud sql instances describe [INSTANCE_NAME] to get information about the instance, or gcloud sql instances restart [INSTANCE_NAME] to attempt a restart.

  3. Adjust Resources: If you have reduced the resources too much, it might be causing the instance to become unresponsive. If possible, try to increase the CPU and RAM to previous levels.

  4. Create a New Instance: As a last resort, you might consider creating a new Cloud SQL instance with appropriate resources and migrating the data from the old instance. Make sure to take necessary backups before proceeding with this step