Zero Downtime Upgrade

You might try ogr2ogr - it can do postgres to postgres as easily as Postgres to something else and I think can do databases, schemas or individual tables in a single command

Though your original stays up, I'd recommend not writing to it while being copied...

Brent Wood

On Tuesday, November 9, 2021, 01:51:46 PM GMT+13, Akheel Ahmed <akheel.mailing.list@gmail.com> wrote:

Hi Group

What tools exist besides bucardo, londiste and rubyrep for logical replication to do a zero/near zero downtime upgrade?

Thanks in advance