AW: AW: Reducing bandwidth usage of database replication

Thanks, the wal_sender_timeout setting was the culprit! A bit hard to find that it influences a ping at half its interval time though. Sascha Zenglein Produktentwicklung [cid:gessler_email_logo_23bb5200-2c8c-4c2d-a63e-71d5bf29d89f.gif] Gessler GmbH

AW: Reducing bandwidth usage of database replication

wal_receiver_timeout = 1200s wal_receiver_timeout = 65s recovery_min_apply_delay = 600s The random values were to see which setting is limiting if I got above the 30s limit. Sascha Zenglein Produktentwicklung [cid:gessler_email_logo_23bb5200-2c8c-4c2d-a63e-71d5bf29d89f.gif

AW: Reducing bandwidth usage of database replication

It is, unfortunately, too much for our requirements. I was able to increase wal_receiver_status_interval so that the publisher only contacts the subscriber every 30 seconds instead of every 10. But I am not able to increase it further. Sascha Zenglein Produktentwicklung

Reducing bandwidth usage of database replication

. I'm also open for other solutions if anything comes to mind! Thanks for the help! Sascha Zenglein Produktentwicklung [cid:gessler_email_logo_23bb5200-2c8c-4c2d-a63e-71d5bf29d89f.gif] Gessler GmbH Gutenbergring 14 63110 Rodgau Deutschland Tel.: +49 6106