[google-cloud-sql-discuss] Re: Upgrading Postgres from 9.6 to 13

I have not been able to find a way to keep the IP as an upgrade of the Postgres version requires you to create a new Cloud SQL instance [1] and there is no way to assign an IP to it. 

An option to prevent this situation is to use the Cloud SQL Auth proxy [2]. Using it will avoid the need of connecting to the instance using a static IP

[1]: https://cloud.google.com/sql/docs/postgres/upgrade-db

[2]: https://cloud.google.com/sql/docs/postgres/sql-proxy#what_the_provides

On Tuesday, June 1, 2021 at 9:05:25 AM UTC+2 bogu...@gmail.com wrote:

I'd like to be able to upgrade my existing cloudsql postgres 9.6 instance to 11 to use some new pg 11 features.

I need to keep the same IP as the instance with 9.6. There are many applications.

I accept suggestion of less important strategies.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/61e27a90-0792-453c-b12f-85a8ac188ad4n%40googlegroups.com.