Downtime is not mandatory while upgrading to a new PostgreSQL version. I've upgraded from 9.0 to 11 and most versions in between without downtime on large busy databases.
There's not a single approach that works for every case, but they all involve a replica and upgrading one at a time.
Comments
Downtime is not mandatory while upgrading to a new PostgreSQL version. I've upgraded from 9.0 to 11 and most versions in between without downtime on large busy databases.
There's not a single approach that works for every case, but they all involve a replica and upgrading one at a time.