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
