
Episode 146
How to move off RDS
Postgres FM · Nikolay Samokhvalov and Michael Christofides
May 30, 202547m 33s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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
Topics
PostgresPostgreSQLDatabasesSQLtechnology