Understanding Logical Replication Setup in PostgreSQL

Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases.
 
Here are some links to things they mentioned:

• Patroni https://github.com/patroni/patroni
• pgBackRest https://github.com/pgbackrest/pgbackrest
• WAL-G https://github.com/wal-g/wal-g
• Hetzner Cloud https://www.hetzner.com/cloud
• Postgres Extensions Day https://pgext.day
• pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling
• pg_stat_kcache https://github.com/powa-team/pg_stat_kcache
• auto_explain https://www.postgresql.org/docs/current/auto-explain.html
• Fivetran https://www.fivetran.com
• pgcopydb https://github.com/dimitri/pgcopydb
• Kafka https://kafka.apache.org
• Debezium https://debezium.io
• max_slot_wal_keep_size https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-SLOT-WAL-KEEP-SIZE
• log_statement DDL https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-STATEMENT
• PgBouncer pause/resume https://www.pgbouncer.org/usage.html#pause-db

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

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

With credit to:

• Jessie Draws for the elephant artwork