| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Yambu <hyambu(at)gmail(dot)com>, Holger Jakobs <holger(at)jakobs(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Logical replication alternative |
| Date: | 2020-11-04 15:35:08 |
| Message-ID: | 95a62c9dc6e707ae6181f3146b521c7a7e29cd49.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2020-11-04 at 13:34 +0200, Yambu wrote:
> > Why do you need an alternative to logical replication? Please tell us
> > why logical replication isn't for you.
>
> 1. We want to update the few tables once a day
> 2. We want to avoid restart the mission critical database, changing wal_level requires a restart
I think that you should plan the restart - it is only a short downtime.
All the other solutions (Skytools, Slony, ...) are way more invasive:
they will create triggers on your precious database, which can slow
down data modifications considerably.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yambu | 2020-11-05 13:33:54 | Query cost |
| Previous Message | Thomas Kellerer | 2020-11-04 11:58:33 | Re: Logical replication alternative |