High Availability PostgreSQL

2 months 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

32 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

a year ago

native integration with AWS or Supabase for db would be great


yakuo
PRO

4 months ago

What is the status of this task?


fra
HOBBYTop 10% Contributor

4 months ago

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


icueth
PRO

3 months ago


Railway
BOT

2 months 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 about 2 months ago


chandrika
EMPLOYEE

2 months 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

2 months 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

2 months 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

2 months 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

2 months ago

This link is no longer working


sungkhum
PRO

2 months ago

Can Railway impliment this? Please?


sungkhum
PRO

2 months 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 about 2 months ago


Status changed to Completed Railway about 2 months ago


dev-louis
HOBBY

2 months 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?


fra
HOBBYTop 10% Contributor

2 months ago

thanks to ship this and to have shipped pg 18 as well, I have just one question, I know you can't answer with a real number, but more or less, how much would cost to run postgres in HA instead of a single node? for sure the cost of the replicas cpu/memory/storage, but what about etcd Nodes & HAProxy how much these will consume in terms of resources?


sungkhum
PRO

2 months ago

Also, what are the exact steps to upgrade an existing postgres to high availability?


sungkhum

Also, what are the exact steps to upgrade an existing postgres to high availability?

fra
HOBBYTop 10% Contributor

2 months ago


dev-louis
HOBBY

2 months ago

You have to enable it in Priority Boarding then select the db mode > config > convert to HA


sungkhum
PRO

2 months ago

I turned on Priority Boarding and and Postgres High Availablity, but still not seeing anything in my db->settings to enable HA


dev-louis
HOBBY

2 months ago

You should see the option to convert under Database > Config

Attachments


dev-louis

You should see the option to convert under Database > Config

sungkhum
PRO

2 months ago

Ah, thank you!


sungkhum
PRO

2 months ago

I'm using a pgvector template for one of my databases, so for that one, looks like it is unavailable. But I see it on other normal Postgres installs.


louisdeconinck
PRO

a month ago

Does anyone have a rough estimate on how much more HA Postgres costs vs normal Postgres?


genai_works
PRO

a month ago

I want to be able to control these options, seems not possible right now. It could be part of interface (Config)

ALTER SYSTEM SET max_connections = 500;
ALTER SYSTEM SET shared_buffers = '8GB';
ALTER SYSTEM SET effective_cache_size = '24GB';
ALTER SYSTEM SET maintenance_work_mem = '1GB';
ALTER SYSTEM SET work_mem = '16MB';
ALTER SYSTEM SET max_worker_processes = '24';
ALTER SYSTEM SET max_parallel_workers_per_gather = '6';
ALTER SYSTEM SET max_parallel_workers = '24';

SELECT pg_reload_conf();

RAILWAY_SHM_SIZE_BYTES=524288000


punchdrunk
PRO

a month ago

I'm relatively new to this architecture - what criteria should I look at to determine if I should upgrade to a HA cluster instead of my standard single DB?


y-pakorn
PRO

a month ago

do we have any expected downtime and/or connection url changes when upgrading to HA?


Welcome!

Sign in to your Railway account to join the conversation.

Loading...