High Availability for PostgreSQL
complete
Anurag Goel
Automatically promote a follower PostgreSQL instance if/when the primary instance goes down.
Log In
Stephen Barlow
High availability for Render PostgreSQL is officially launched.
Teams with a database on a
Pro
instance type or higher can enable high availability (HA) for that database from the Render Dashboard. With HA enabled, Render automatically fails over to your database's standby instance whenever your primary instance encounters an issue. HA also shortens your database's routine maintenance windows to under one minute.Learn more in the documentation.
T
Team Caido
Stephen Barlow Is there any plan to offer HA to lower tiers (at least standard)? The Pro databases start at 95$/m per database which is out of the price range for a lot of people especially if you run multiple databases.
Stephen Barlow
complete
Stephen Barlow
High availability for Render PostgreSQL is officially launched.
Teams with a database on a
Pro
instance type or higher can enable high availability (HA) for that database from the Render Dashboard. With HA enabled, Render automatically fails over to your database's standby instance whenever your primary instance encounters an issue. HA also shortens your database's routine maintenance windows to under one minute.Learn more in the documentation.
Stephen Barlow
Support for High Availability PostgreSQL on Render is code-complete!
Before we release this feature to all teams, we'll enable it for a small group of teams who are interested in early access. This period will help us ensure a smooth rollout to general availability.
If your team is interested in early access (planned to start in the next few weeks), please submit this form to apply: https://forms.gle/qzCZ2Q7sVXRDCxB88
Note the following requirements:
- Your database must belong to a team account.
- Your database's instance type must be ProorPro Plus.
- Your database must run PostgreSQL version 13 or later.
Additional details are available in the application form. Note that we can't guarantee a response for all applications.
Thank you!
E
Evan Arnold
Do you plan on this also having point-in-time backups? That is the feature that I need in order to use Render.
fwiw - this is a key feature for many SOC2-esque certifications, so is likely a blocker for growing SaaS companies selling into enterprise.
Anurag Goel
Evan Arnold: We're prioritizing Point-In-Time Recovery and will roll it out before we ship HA.
S
Sean Yu
My 2 cents - just want to make sure that we have the option to turn this feature off, or have it off by default. For applications that care about high data accuracy, I don't believe this can be done safely with Postgres
Anurag Goel
in progress
Anurag Goel
planned
K
Kannan Goundan
Just one data point: I was thinking about using Render or Heroku for our application, but the lack of HA pushed me towards AWS/GCP. It wasn't a total dealbreaker -- I could have used Render/Heroku with an AWS DB, but I decided to stick with a single provider.
(Heroku has HA, but it's async replication and will likely lose some data on failover: <https://devcenter.heroku.com/articles/heroku-postgres-ha>. I was very surprised to learn this!)