Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-15 Thread William Yu
Johnny Ljunggren wrote: William Yu wrote: What I'm not sure about though is what would happen with 2 slaves if main goes down AND the connection between center 1 & 2 is also disconnected. Others with more experience with the various master/slave replication solutions might want to chime in no

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-15 Thread Christopher Browne
> William Yu wrote: >> Johnny Ljunggren wrote: >> >>> 1. Replication - multimaster >>> I'll try to explain the setup to the best of my ability: >>> Three centers: >>> Main center - database with a backup database >>> Center 1 - database with a backup database >>> Center 2 - database with a backup d

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-15 Thread Johnny Ljunggren
William Yu wrote: Hmm, okay. We're now looking at another, simpler, way to do it. The same setup but the clients on Center 1/2 will connect directly to the Main center (2Mb leased line). The databases on Center 1/2 will then just be a replica of the Main databases. The biggest issue though is

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-14 Thread William Yu
Johnny Ljunggren wrote: Hmm, okay. We're now looking at another, simpler, way to do it. The same setup but the clients on Center 1/2 will connect directly to the Main center (2Mb leased line). The databases on Center 1/2 will then just be a replica of the Main databases. The biggest issue thou

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-14 Thread Jim C. Nasby
On Mon, Nov 14, 2005 at 06:02:03PM +0100, Johnny Ljunggren wrote: > Scott Ribe wrote: > >>From what I understand this will be possible but I may need to roll my > >>own replication code to handle data conflict issues? Especially since > >>center 1/2 may be down at the same time and then might chang

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-14 Thread Johnny Ljunggren
Scott Ribe wrote: From what I understand this will be possible but I may need to roll my own replication code to handle data conflict issues? Especially since center 1/2 may be down at the same time and then might change the same data. How do the tools for this compare against the ones from Oracl

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-14 Thread Johnny Ljunggren
William Yu wrote: Johnny Ljunggren wrote: 1. Replication - multimaster I'll try to explain the setup to the best of my ability: Three centers: Main center - database with a backup database Center 1 - database with a backup database Center 2 - database with a backup database (same as center 1)

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-12 Thread vishal saberwal
hi johny, would pgreplicator help ... i am not sure if it would solve your purpose but may be you want to look at it ... it does offer multimaster replication ... thanks, vishOn 11/11/05, William Yu <[EMAIL PROTECTED]> wrote: Johnny Ljunggren wrote:> 1. Replication - multimaster> I'll try to exp

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-11 Thread William Yu
Johnny Ljunggren wrote: 1. Replication - multimaster I'll try to explain the setup to the best of my ability: Three centers: Main center - database with a backup database Center 1 - database with a backup database Center 2 - database with a backup database (same as center 1) Application on the t