Hey everyone! I've been hearing a lot about transitioning from Heroku to managing my own VPS, especially for my large application. I'm really concerned about my database during this move, mainly because it's about 2 TB in size. My main worries are:
1.) I'm anxious about downtime when using pg_dump since Heroku's limitations on read replicas seem to leave me with no choice but to go this route.
2.) I'm aware that Heroku handles a lot of maintenance for my database, and I want to ensure that I can replicate or even improve upon that on my own. Are there any reliable PaaS options that can help?
I'd love to hear from anyone who has experience doing this for production apps. Thanks in advance!
1 Answer
I totally get where you're coming from! I've talked about this in some groups, and the general advice I got was to maybe keep your DB on a managed service like Heroku or AWS RDS. They handle backups and updates, which is super important to prevent data loss. For me, I decided to stick with AWS RDS after switching from Heroku. Plenty of resources out there for migration, but having automatic updates is definitely a plus unless you're really into DevOps and database management.
I'm currently using Dokploy, which also supports backups. My main worry is keeping up with the maintenance tasks that Heroku performs periodically; I'm not sure I can cover all that just with auto vacuums.