Nikolay and Michael discuss self-managing Postgres — both the practicalities of doing so, as well as some managed-service style tooling.

Here are some links to some things they mentioned:

  • Our episode on Managed services vs. DIY https://postgres.fm/episodes/managed-services-vs-diy
  • WAL-G https://github.com/wal-g/wal-g
  • pgBackRest https://pgbackrest.org/
  • Barman https://github.com/EnterpriseDB/barman
  • Dead Man’s Snitch https://deadmanssnitch.com/
  • Netdata https://www.netdata.cloud/
  • Upgrades https://postgres.fm/episodes/upgrades
  • High availability https://postgres.fm/episodes/high-availability
  • Configuration https://postgres.fm/episodes/default-configuration
  • Corruption https://postgres.fm/episodes/corruption
  • Connection poolers https://postgres.fm/episodes/connection-poolers
  • Index maintenance https://postgres.fm/episodes/index-maintenance
  • StackGres supported extensions (Michael was wrong, it also has a timescale_tls extension!) https://stackgres.io/extensions/
  • postgresql_cluster https://github.com/vitabaks/postgresql_cluster
  • Supabase self-hosting https://supabase.com/docs/guides/self-hosting
  • Tembo https://github.com/tembo-io/tembo
  • Open source licenses, clouds, Postgres (Postgres TV discussion) https://www.youtube.com/watch?v=1rcbyIjA4gI&t=149s

~~~

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 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