High Availability PostgreSQL

8 days ago

We're making it easy to upgrade a standalone PostgreSQL database to a highly available cluster with automatic failover — and just as easy to roll back if you need to.

Today, going from a single Postgres instance to an HA setup means a painful migration. We're adding a one-click conversion that handles the upgrade for you, automatically updates your connection strings to point to the right place, and gives you a clean cluster management view so you can see the health of your replicas without getting lost in the details. This is the foundation for HA support across more database types in the future.

What does your ideal HA database experience look like? Let us know in the comments!

Completed

0 Threads mention this feature

20 Replies

mick
TRIAL

2 years ago

3 years ago and this is still open? It is a default with other providers, e.g. Render


mo6zes
PRO

2 years ago

Watching


We have a few HA templates that users deploy while on the platform. Melissa, our Solutions Engineer, have a few of them being flighted and then we plan to take the learnings from that project over to the native offering on the platform.


brent-hoover
PRO

2 years ago

Just +1'ing this as this would be great to just add this with a click


Then I'm happy to announce we now have a Highly available Postgres template - https://railway.app/template/ha-postgres

Try it out and let us know what you think please!


watching. I would like to be able to deploy read replicas across regions too


We are looking to split this work up- what would you say is “Minimally Lovable Managed Postgres”?

I am thinking one button version upgrades. I know some others want smart replication.


+1 for multi region replication to have multi region reads.


bveiseh
PRO

9 months ago

native integration with AWS or Supabase for db would be great


yakuo
PRO

3 months ago

What is the status of this task?


fra
HOBBYTop 10% Contributor

3 months ago

I think there is a new template for this, you should be able to find it in the template page


icueth
PRO

2 months ago


Railway
BOT

8 days ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Planned Railway 8 days ago


chandrika
EMPLOYEE

8 days ago

Hi folks, the High Availability PostgreSQL project has been moved to planning raised_hands emoji!!

TLDR: we're making it easy to upgrade a standalone PostgreSQL database to a highly available cluster with automatic failover, and just as easy to roll back if you need to.

What's your ideal HA database experience look like?


chandrika

Hi folks, the High Availability PostgreSQL project has been moved to planning !! TLDR: we're making it easy to upgrade a standalone PostgreSQL database to a highly available cluster with automatic failover, and just as easy to roll back if you need to.What's your ideal HA database experience look like?

yakuo
PRO

8 days ago

This is really great news. Railway needed a feature like this. Hopefully it will be available soon.


chandrika

Hi folks, the High Availability PostgreSQL project has been moved to planning !! TLDR: we're making it easy to upgrade a standalone PostgreSQL database to a highly available cluster with automatic failover, and just as easy to roll back if you need to.What's your ideal HA database experience look like?

fra
HOBBYTop 10% Contributor

8 days ago

will this be a managed db? or is it still an unmanaged db? will we be able to have replica in different regions?


brody

Then I'm happy to announce we now have a Highly available Postgres template - https://railway.app/template/ha-postgresTry it out and let us know what you think please!

andyslack
PRO

5 days ago

Watching


brody

Then I'm happy to announce we now have a Highly available Postgres template - https://railway.app/template/ha-postgresTry it out and let us know what you think please!

andyslack
PRO

5 days ago

This link is no longer working


sungkhum
PRO

3 days ago

Can Railway impliment this? Please?


sungkhum
PRO

3 days ago

Something like this: https://render.com/docs/postgresql-high-availability
So when something goes down on Railway's end (like today) our apps don't go down.


Status changed to In Progress Railway 2 days ago


Status changed to Completed Railway 2 days ago


dev-louis
HOBBY

8 hours ago

This sounds really cool and I'm glad to see its now 'Completed', but can't seem to see any documentation on this, or option to upgrade to the HA setup. How is this done please?


Loading...