I have an instances PostgreSQL 11 on production of a web application. Now, i want to modify the connectivity part to use internal IP and disable the public connection. Do this activity make a little downtime for our DB?
I have guest on my own:
GCP only changes the network part of this instances so we can get zero downtime.
GCP will re-configure the instance host this PostgreSQL and this make a little downtime for our DB, the thing we dont want with our production.
Tks in advance!
Given the fact that you are using Cloud SQL for PostgreSQL, you can consider the following from the Documentation:
For most instance settings, Cloud SQL applies the change immediately and connectivity to the instance is unaffected.
Changing the number of CPUs, memory size, or the zone of the instance results in the instance going offline for several minutes. You should plan to make these kind of changes when your application can handle an outage of this length.
As per the documentation, besides changing the number of CPUs, memory size, and zone of the instance, configuring an existing instance to use private IP, or changing the network it is connected to, causes the instance to be restarted. This causes a few minutes of downtime.