I am looking for a way to be able to setup a postgresql database on linux and mirror the database on a second server, keeping both databases syncronized in real-time. I'm not sure this would be considered a distributed database (although I'm open to suggestions on how to do that too), I'm hoping it is possible to set this up similar to load-balancing with multiple web servers. I'm wondering if I could have this effect by pointing two separate postgresql installations to the same logical database file group? Basically I want to set this up for performance boosts in an enterprise environment, I would have other servers for backup purposes. Any suggestions or help would be greatly appreciated.
Thanks!