Changing database flags

Google Cloud Database
1

https://cloud.google.com/sql/docs/postgres/flags

This command will overwrite all database flags previously set. To keep those and add new ones, include the values for all flags you want set on the instance; any flag not specifically included is set to its default value.

This is really inconvenient. Please provide a way to change only the flag user has specified. Leave other flags untouched. Do not reset them to default values.

In the meantime, is there a script that can achieve desired behavior? we have a cloud SQL instance and we made changes to several parameters and have not tracked what parameters we changed. now we want to introduce another change and don’t want to undo changes we made previously to the flags.

2

Flags can be set via the console, gcloud, Terraform or rest API

To keep database flags previously set and add new ones, include the values for all flags you want set on the instance; any flag not specifically included is set to its default value. For flags that do not take a value, specify the flag name followed by an equals sign (“=”).