From: TomDB <tomdb@uk2.net>
To: pgsql-admin@postgresql.org
Subject: Re: replication?
Date: Tue, 14 Nov 2006 22:10:53 +0100
Message-ID: <1807736772.20061114221053@uk2.net> (raw)
In-Reply-To: <20061114171835.GY90133@nasby.net>
References: <322616614.20061113222140@uk2.net>
<20061114171835.GY90133@nasby.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tomdb@uk2.net
Subject: Re: replication?
In-Reply-To: <1807736772.20061114221053@uk2.net>
References: <322616614.20061113222140@uk2.net> <20061114171835.GY90133@nasby.net> <1807736772.20061114221053@uk2.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox