Postgresql Distributed Database

Reply

Join Date: Aug 2004
Posts: 12
Reputation: AK47 is an unknown quantity at this point 
Solved Threads: 0
AK47 AK47 is offline Offline
Newbie Poster

Postgresql Distributed Database

 
0
  #1
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!
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 521
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Postgresql Distributed Database

 
0
  #2
May 30th, 2006
I believe this is what you're looking for.

If you're using pgadmin then this may also be of interest to you
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC