Re: [GENERAL] do I need replication or something else?

2005-04-15 Thread Andrew Sullivan
On Tue, Mar 29, 2005 at 04:06:57PM -0600, Caleb Simonyi-Gindele wrote: Yes, we use it successfully with the SQL Server edition of our product. Does anyone know if this is available with Postgre? Caleb Out of the box, the answer is, No. It is not an insurmountable problem, however, and I can

Re: [GENERAL] do I need replication or something else?

2005-04-03 Thread Jeff Davis
On Tue, 2005-03-29 at 12:58 -0600, Caleb Simonyi-Gindele wrote: We have a billing system and we want the ability to send users out into the field with an unconnected (no WAN, VPN etc) laptop containing our pg db and software. Upon their return we need to synchronize changes to the main db.

Re: [GENERAL] do I need replication or something else?

2005-04-03 Thread Jeff Davis
I agree with your disagreement. This design is present in lots of non-RDB systems - CVS, IMAP, PDA syncing, etc. It's clearly more complicated, but can be made to work, and has been many times. I don't see anything about databases in general, or Postgres specifically, that indicates

[GENERAL] do I need replication or something else?

2005-03-29 Thread Caleb Simonyi-Gindele
We have a billing system and we want the ability to send users out into the field with an unconnected (no WAN, VPN etc) laptop containing our pg db and software. Upon their return we need to synchronize changes to the main db. We would like the ability to be able to have this accomplished at

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Dann Corbit
broken. IMO-YMMV. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caleb Simonyi-Gindele Sent: Tuesday, March 29, 2005 10:58 AM To: pgsql-general@postgresql.org Subject: [GENERAL] do I need replication or something else? We have a billing system and we want

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Guy Rouillier
Dann Corbit wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I'm relatively new to PostgreSQL so won't comment about that. But some DBMSs have this feature built in because it is a fairly common

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread John Burger
If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I would respectfully disagree that the requirement for two-way replication indicates a broken design. I agree with your disagreement. This design is present

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Caleb Simonyi-Gindele
John Burger wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I would respectfully disagree that the requirement for two-way replication indicates a broken design. I agree with your disagreement.

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Yudie Pg
On Tue, 29 Mar 2005 16:00:37 -0500, John Burger [EMAIL PROTECTED] wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I would respectfully disagree that the requirement for two-way replication

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Scott Marlowe
On Tue, 2005-03-29 at 16:06, Caleb Simonyi-Gindele wrote: John Burger wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I would respectfully disagree that the requirement for two-way

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Tony Caduto
If you are using Delphi you can use the tclientdataset which has a Briefcase type system built in. Or you can use one of the many middleware systems that are available for Delphi, all of which will do what you want. www.remobjects.com www.astatech.com etc etc Most of them work by creating a XML

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Caleb Simonyi-Gindele) would write: John Burger wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. I would respectfully disagree that the