You can use logical replication if new version of your postgres is on other host.
Best regards!
Domen Šetar Computer Systems Support IZUM – Institute of Information Science| Prešernova ulica 17 | 2000 Maribor |Slovenia T: +386 2 25 20 339| M: +386 41 676 342| www.izum.si|domen.setar@izum.si
From: Wasim Devale <wasimd60@gmail.com> Sent: Wednesday, June 11, 2025 8:54 AM To: Laurenz Albe <laurenz.albe@cybertec.at> Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org> Subject: Re: Upgrade from 12.22 to 16
I mean to say that we do not want to do the in place upgrade also the other option of taking dump and restoration of it. If I can have any robust plan who all have worked on that then please suggest me.
On Wed, 2025-06-11 at 11:51 +0530, Wasim Devale wrote: > Please suggest me to upgrade postgresql: 400 GB data with minimal downtime apart > from in place upgrade. We have it on red hat 9.