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
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:
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.
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.
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.