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!

I believe this is what you're looking for.

If you're using pgadmin then this may also be of interest to you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.