Why PostgreSQL High Availability Matters and How to Achieve It • Hacker News Board

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

#21

Post by candiddevmike » Wed, Jun 14, 2023, 4:47 PM UTC

porsager wrote: post #11

whitepoplar wrote: post #7

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...

What about BU/DR? Is walg still the best?

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

#22

Post by paulddraper » Wed, Jun 14, 2023, 4:53 PM UTC

chzblck wrote: post #5

BrentOzar wrote: post #2

Or, uh, just use AWS RDS Aurora.

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

Perfectly for me.

(Maybe if I had used IAM auth for the database it wouldn't have?)

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

#23

Post by benglish11 » Wed, Jun 14, 2023, 4:54 PM UTC

zorgmonkey wrote: post #20

I_am_tiberius wrote: post #16

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...

Citus is owned by Microsoft as well.

https://blogs.microsoft.com/blog/2019/01/24/microsoft-acquir...

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

#24

Post by paulddraper » Wed, Jun 14, 2023, 4:54 PM UTC

whitepoplar wrote: post #13

porsager wrote: post #11

Earlier quoted context omitted.

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.

Same.

But major upgrades are only available once a year.

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

#25

Post by I_am_tiberius » Wed, Jun 14, 2023, 4:55 PM UTC

benglish11 wrote: post #23

zorgmonkey wrote: post #20

Earlier quoted context omitted.

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...

Citus is owned by Microsoft as well. https://blogs.microsoft.com/blog/2019/01/24/microsoft-acquir...

Yes, the company, but the plugin is some sort of open source.

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

#26

Post by vbezhenar » Wed, Jun 14, 2023, 5:01 PM UTC

whitepoplar wrote: post #7

Topgamer7 wrote: post #3

Earlier quoted context omitted.

Or, uh, just self host.

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

I hosted postgres with cnpg operator in kubernetes. It does everything automagically: backups, wal backups and high-availability. Can't say nothing bad about it, it just worked for me. My only issue is that it releases versions too fast, I'd prefer some more relaxed schedule, but that's probably just me.

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

#27

Post by vocatan » Wed, Jun 14, 2023, 5:01 PM UTC

Another option for open source aficionados might be https://www.pgedge.com - with their spock extension they also achieve multi-master replication. Looks very interesting!

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

#28

Post by franckpachot » Wed, Jun 14, 2023, 5:04 PM UTC

I_am_tiberius wrote: post #16

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 has Spanner. AWS is working on something similar. And both have YugabyteDB in their marketplace. Those are Distributed SQL (Global ACID), not Citus. For DataWarehouse which doesn't need ACID, there are other services.

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

#29

Post by iotapi322 » Wed, Jun 14, 2023, 5:07 PM UTC

I just implemented master with read replica with the bitnami postgres-repmgr image. It's not perfect, but it works and running my own instances in aws instead of rds is going to save me close to 80% when i also add in purchasing a savings plan. By setting this up I've learned more about postgres than i ever ever wanted too. lol

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

#30

Post by chungy » Wed, Jun 14, 2023, 5:08 PM UTC

zorgmonkey wrote: post #20

I_am_tiberius wrote: post #16

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...

I personally don't consider the AGPL to be a free software nor open source license. The burden it places on operating and using the software sufficiently violates freedom 0 in my view.