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