Replication | Postgres.FM 024 |

Nikolay takes Michael through the different replication options for Postgres — looking at different use cases, the options for each, and some things to be careful with.

Here are links to a few things we mentioned:
• Replication (docs) https://www.postgresql.org/docs/curre...
• 9.0 release notes (including built-in replication) https://www.postgresql.org/docs/9.0/r...
• Slony https://www.slony.info/
• Londiste https://github.com/pgq/londiste
• pg_is_in_recovery (pgPedia page) https://pgpedia.info/p/pg_is_in_recov...
• Patroni https://github.com/zalando/patroni
• Multiple Databases with Active Record https://guides.rubyonrails.org/active...
• hot_standby_feedback (docs) https://www.postgresql.org/docs/curre...
• ... and when this 👆 is off, this defines standby's behavior for long-running transactions: max_standby_archive_delay https://postgresqlco.nf/doc/en/param/... (for WAL-shipping) or max_standby_streaming_delay https://postgresqlco.nf/doc/en/param/... (for streaming)
• synchronous_commit and synchronous replicas: https://postgresqlco.nf/doc/en/param/..., https://postgresqlco.nf/doc/en/param/... ("Even when synchronous replication is enabled, individual transactions can be configured not to wait for replication by setting the synchronous_commit parameter to local or off.")
• Database Lab Engine https://postgres.ai/docs/database-lab
• Neon Branching https://neon.tech/docs/introduction/b...
• Past, Present, and Future of Logical Replication (Postgres TV with Amit Kapila)    • Amit Kapila. Past, Present, and Futur...  
• Failover of logical replication slots in Patroni (Postgres TV with Alexander Kukushkin)    • Alexander Kukushkin. Failover of logi...  
• PostgreSQL Subtransactions Considered Harmful (blog post by Nikolay) https://postgres.ai/blog/20210831-pos...
• Why we spent the last month eliminating PostgreSQL subtransactions (blog post by GitLab) https://about.gitlab.com/blog/2021/09...
• Fivetran https://www.fivetran.com/

-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  

~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard

~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.