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
