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?

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

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

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

_________________
Matt Nordhoff (aka Peng on IRC)