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

George, I think this is a legit question by Alex! I have a few database with lots and lots of securitie  around them. Migrating the existing 9.6 to 11 manually could break the system depending on the DB. I think there should be a supported way by GCP to do in-place upgrade.

Thoughts?

On Friday, September 20, 2019 at 10:24:24 AM UTC-7, George (Cloud Platform Support) wrote:

Hello Alex, 

You may also consider creating a replica and performing the export operation from that replica. There are various strategies to reduce impact on users when migrating your database; you may find relevant information on the Web, for instance the "Time reduction battle while migrating databases from hosted PostgreSQL to Google Cloud SQL" page. 

It may be worthwhile noting here that Google Groups are reserved for general product discussions. We cannot provide you any advice on your system's architecture, and related best solutions. For programming, database management, system architecture, you may publish detailed information in forums such as stackoverflow, where experienced programmers are happy to help.

--
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/0c73c188-7877-4f31-8845-01de94476085%40googlegroups.com.