| From: | Brent Wood <pcreso(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Akheel Ahmed <akheel(dot)mailing(dot)list(at)gmail(dot)com> |
| Subject: | Re: Zero Downtime Upgrade |
| Date: | 2021-11-09 01:18:18 |
| Message-ID: | 974171759.2571006.1636420698509@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)mailing(dot)list(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shubham Mittal | 2021-11-09 14:31:02 | Query Timeout not working using jpa |
| Previous Message | Akheel Ahmed | 2021-11-09 00:51:27 | Zero Downtime Upgrade |