Differences Between Physical and Logical Replication in Postgres

Here are links to a few things we mentioned: 

• Replication (docs) 
• 9.0 release notes (including built-in replication) 
• Slony
• Londiste
• pg_is_in_recovery (pgPedia page) 
• Patroni 
• Multiple Databases with Active Record
• hot_standby_feedback (docs) 
• max_standby_archive_delay or max_standby_streaming_delay (for WAL-shipping and WAL-streaming respectively)
• synchronous_commit
• Synchronous replicas
• Database Lab Engine 
• Neon Branching  
• Past, Present, and Future of Logical Replication (Postgres TV with Amit Kapila)  
• Failover of logical replication slots in Patroni (Postgres TV with Alexander Kukushkin)  
• PostgreSQL Subtransactions Considered Harmful (blog post by Nikolay) 
• Why we spent the last month eliminating PostgreSQL subtransactions (blog post by GitLab) 
• Fivetran 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork