Follower databases
M
Marc Köhlbrugge
The recent release of Postgres 12 and 13 are a welcome addition.
However, dumping and restoring a large database can take quite some time leading to long downtime.
It would be great if Render had Heroku-like follower databases.
Let's say you had a Postgres v11 database. Then this feature would allow you to create a new Postgres v13 database that "follows" the v11 database. Once the data is pretty much synced, you can put the whole app in maintenance mode. Wait for the last bit of a data to sync, so v13 is fully up-to-date. Then switch to that database as your primary one, and delete the old v11 database.
Log In
J
Jack Collins
Is this supported with Read Replicas now? https://docs.render.com/postgresql-read-replicas
M
Marc Köhlbrugge
Just reiterating my need for this. It can take 2+ hours just go through the process of exporting/dumping a large database. Since there can be no data written to the database during this period, this essentially means 2+ hours of downtime. (And if something goes wrong like it did in my case, it will be even longer).