Postgresql Distributed Database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 427,427 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,529 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

Thread Tools Display Modes

Views: 3613 | Replies: 1

•

Join Date: Aug 2004

Posts: 12

Reputation: AK47 is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

AK47

Offline

Newbie Poster

Postgresql Distributed Database

May 23rd, 2006

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!