Live data from Hacker News

Why PostgreSQL High Availability Matters and How to Achieve It

yugabyte.com

11–20 of 86 posts

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#11

Earlier quoted context omitted.

Or, uh, just self host.

What's the self-hosted Postgres HA story these days?

pg_auto_failover makes it an absolute breeze. I cannot understand how it's not mentioned in the article.

I've been runnning it for over 3 years with great success, and 0 downtime. Not to mention the extreme price difference compared to managed solutions - https://github.com/hapostgres/pg_auto_failover/discussions/6...

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#12
post #5

Earlier quoted context omitted.

How did that work out for people in the east region yesterday?

not good lol

yeah... no burgers or tacos https://www.theverge.com/2023/6/13/23759857/amazon-aws-down-...

that's WHY you need at least a multi-region HA database for your apps

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#13

Earlier quoted context omitted.

What's the self-hosted Postgres HA story these days?

pg_auto_failover makes it an absolute breeze. I cannot understand how it's not mentioned in the article. I've been runnning it for over 3 years with great success, and 0 downtime. Not to mention the extreme price difference compared to managed solutions - https://github.com/hapostgres/pg_auto_failover/discussions/6...

How are major version upgrades handled on PGAF these days? Last time I used it (it's amazing), there wasn't a great path forward for minimal-downtime major version upgrades.

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#14

Earlier quoted context omitted.

What's the self-hosted Postgres HA story these days?

pg_auto_failover makes it an absolute breeze. I cannot understand how it's not mentioned in the article. I've been runnning it for over 3 years with great success, and 0 downtime. Not to mention the extreme price difference compared to managed solutions - https://github.com/hapostgres/pg_auto_failover/discussions/6...

zero downtime for three years - congrats !

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#17

Earlier quoted context omitted.

not good lol

yeah... no burgers or tacos https://www.theverge.com/2023/6/13/23759857/amazon-aws-down-... that's WHY you need at least a multi-region HA database for your apps

No Roomba either. No multi-tasking housework while you work.

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#19
post #15

Very Interesting. Glossing over the article, it states HA within a Region. Curious if anyone is successful in running any Database with multi-region HA? How are you doing it?

There's another article from them that covers it https://www.yugabyte.com/blog/exploring-multi-region-databas...

Re: Why PostgreSQL High Availability Matters and How to Achieve It

#20

I wished AWS, Google and others would also add a Citus solution. I fear that once migrated to Citus, we face the full price pressure from the Azure monopoly.

Google will never touch Citus because it is AGPL licensed[0], I wouldn't be surprised if the other cloud providers have similar policies.

[0] https://opensource.google/documentation/reference/using/agpl...

Post reply on HN