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