Postgres FM

How to move off RDS

May 30, 2025
The discussion centers around moving away from managed PostgreSQL services like RDS, weighing the pros and cons of vendor lock-in versus the flexibility of open-source alternatives. Key migration strategies and tools, like logical replication and Change Data Capture, are highlighted to ease the process. Insights on managing large tables and minimizing downtime during transitions are shared. The speakers also touch on the evolution of managed services and emerging solutions in the open-source landscape.
Ask episode
AI Snips
Chapters
Transcript
Episode notes
INSIGHT

Managed Services Can Suddenly Die

  • Managed Postgres services can suddenly shut down with very short notice, disrupting users.
  • This instability isn't expected from major providers like RDS but happens with smaller ones, causing migration urgency.
INSIGHT

Managed Services Limit Control

  • Managed service providers charge more but limit user control, undermining open source openness.
  • This creates vendor lock-in and prevents users from accessing core features like physical backups or low-level replication.
ADVICE

Check Extensions and Compatibility

  • When migrating off managed Postgres, assess extensions and version compatibility carefully.
  • Prioritize support for updates and observability features to avoid losing critical functionality.
Get the Snipd Podcast app to discover more snips from this episode
Get the app