Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D56709FB203 for ; Tue, 14 Nov 2006 17:11:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 72636-03 for ; Tue, 14 Nov 2006 21:11:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from amsfep15-int.chello.nl (amsfep17-int.chello.nl [213.46.243.15]) by postgresql.org (Postfix) with ESMTP id 69A939FB21A for ; Tue, 14 Nov 2006 17:11:01 -0400 (AST) Received: from ATHLON64 ([213.132.141.117]) by amsfep15-int.chello.nl (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20061114211042.WGJI1719.amsfep15-int.chello.nl@ATHLON64> for ; Tue, 14 Nov 2006 22:10:42 +0100 Date: Tue, 14 Nov 2006 22:10:53 +0100 From: TomDB X-Mailer: The Bat! (v3.85.03) Home Reply-To: TomDB X-Priority: 3 (Normal) Message-ID: <1807736772.20061114221053@uk2.net> To: pgsql-admin@postgresql.org Subject: Re: replication? In-Reply-To: <20061114171835.GY90133@nasby.net> References: <322616614.20061113222140@uk2.net> <20061114171835.GY90133@nasby.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.611 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FORGED_RCVD_HELO, SARE_SPEC_REPLICA X-Spam-Level: * X-Archive-Number: 200611/148 X-Sequence-Number: 23675 would there be any default available field (like the OID of the records) that would be unique in the two versions of the datbase? there isn't "by accident" something like a unique UID like an MD5 or something... ? cause if there is no replication available, I'd consider this (together with PHP) a) replacing the serial fields by generated UID's (md5 of ID + a string that depends on the install) or b) start the autoincrement field at a high number in the second install (since I can estimate that there will never by > 10 000 records) + store all queries that were performed & run them in the network-master afterwards. >> >> I'd like to create a setup where there are exactly 2 masters which >> need to be synchronized against each other. The two masters should >> have read+write access, but don't have a permanent connection to each >> other. One will be on a LAN-server, the other instance will be >> installed on a Windows-client-laptop which can be taken along the >> road. When coming back to the office, we need to sync the changed >> data. >> >> is there any tool that will allow me to do so ? > If you got *really* clever you could maybe pull it off with Slony, but > in general, no, this isn't possible. -- Best regards, TomDB mailto:tomdb@uk2.net