Re: Postgres 12 update to new major version

On 6/5/26 5:11 AM, Boris Dovčík wrote:
> Hello all,
> 
> I have a question regarding the update of the production database 
> (multiple TB of data) from version 12 to higher major version. We would 

How many TB?

> like to jump to 15 or 16. DB is installed on a Linux server with one 
> replica on another, it is not on cloud.

What replication is being done now?

Where are the servers relative to each other network distance wise?

> 
> First question is should we perform updates one by one? 12 -> 13 -> 14 
> etc. or is it viable to jump to 16 right away? (We have few functions 
> but usually its plain tables)
> 
> Second we are contemplating options for the update since we are limited 
> with downtime. We could get 4 hours of downtime for the whole update 
> (either via pg_update or dumps). We are not sure how to estimate the 

Did you mean pg_upgrade?

> time for direct update or dumps. What would be the recommended way for it?
> 
> One option we see could be logical replication to the new major version 
> on a new machine, but we received feedback that in our setup it might 

What was the feedback that indicated it was not advisable?

> not be recommendable. Does it make sense to try logical replica? What 
> would be the downsides of it?
> 
> Best regards,
> Boris Dovčík


-- 
Adrian Klaver
adrian.klaver@aklaver.com