Re: [PERFORM] Mirroring PostgreSQL database

2005-07-27 Thread Sebastian Hennebrueder
Shashi Kanth Boddula schrieb: Hi, I have one customer who is using PostgreSQL 7.4.8 on Linux . He has some problems with database mirroring . The details are follows. The customer is using Linux on which PostgreSQL 7.4.8 along with Jboss 3.2.3 is running . He has 2 servers , one is acting as

Re: [PERFORM] Mirroring PostgreSQL database

2005-07-25 Thread Richard Huxton
Shashi Kanth Boddula wrote: The customer is using DBmirror tool to mirror the database records of primary to secondary . The customer is complaining that there is one day (24 hours) delay between primary and secondray for database synchronization . They have dedicated line and bandwidth , but

Re: [PERFORM] Mirroring PostgreSQL database

2005-07-25 Thread Christopher Kings-Lynne
Try Slony: www.slony.info Shashi Kanth Boddula wrote: Hi, I have one customer who is using PostgreSQL 7.4.8 on Linux . He has some problems with database mirroring . The details are follows. The customer is using Linux on which PostgreSQL 7.4.8 along with Jboss 3.2.3 is running . He has 2

Re: [PERFORM] Mirroring PostgreSQL database

2005-07-25 Thread Joshua D. Drake
I just want to know , for immediate data mirroring , what is the best way for PostgreSQL . PostgreSQL is offering many mirror tools , but which one is the best ?. Is there any other way to accomplish the task ? You want to take a look at Slony-I or Mammoth Replicator. http://www.slony.info/