Postgres and NodeBalancer - possible?

I have no experience with Postgres or NodeBalancer, and I was wondering if what I'm picturing in my head is possible, or if I have a fundamental misunderstanding of any of the technologies involved.

Here's what I imagine: two servers running Postgres. Both are "masters" - can receive write and read queries. Each one replicates the write queries they receive to the other server.

Our apps point their DB address to NodeBalancer, which directs the traffic to one of the two servers. If one happens to go down, NodeBalancer will only direct traffic to the remaining one.

Is this a right-headed understanding of the possibilities of Postgres and NB, or am I wrong in thinking this setup is possible?

4 Replies

Node balancers can only balance external traffic so they won't fit into your plan.

NodeBalancers listen on IPv6 too, and local IPv6 traffic doesn't count against the transfer pool.

-Chris

Although NodeBalancers are always accessible to the public, aren't they? And you might not want that for your private db servers…

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct