Hi all,
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
Can anyone point me to docs/websites that discuss options on
replicating in (as close as possible to) realtime? Ideally with load
balancing while both/all servers are up, and failover/resyncing when a
member fails and is restored.
Is this even possible on PostgreSQL?
Being a quite small company, proprietary hardware and fancy software
licenses are not possible (ie: 'use oracle' won't help).
I've looked at slony, but it looks more like a way to push occasional
copies to slaves, and isn't meant to be real time. Am I wrong by chance?
Thanks for any help/tips/pointers!
Madi