Upgrate Major Version Postgres

Hello,

I’m migrating some apps from Heroku to Render. These apps use PostgreSQL databases in an older version (13). At some point in the future, we will need to upgrade to version 15 or 16, but some of our databases are over 100GB in size.

In Render’s documentation, there is a guide for upgrading major versions (Upgrading Your PostgreSQL Version | Render Docs), but this process involves taking a pg_dump, which can take too long for large databases. My question is: Is there a way to upgrade with no downtime or at least minimal downtime?

Also, in Heroku, we used to schedule database maintenance. Is there a similar feature in Render, or how does database maintenance work?

Hi Jose,

Great news. The team is currently working on this feature.

You can follow this feedback item to get alerted when it’s completed: https://feedback.render.com/features/p/in-place-postgres-version-upgrades.

https://render.com/changelog is another place to check for recent updates; we’ll also post there when this feature is released.

Let me know if you have any other questions about this.

Regards,

Matt