pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (63+ messages)  latest in thread

Message-ID: <1807736772.20061114221053@uk2.net>
Permalink:  ../1807736772.20061114221053@uk2.net/
Also on:    postgresql.org/message-id/1807736772.20061114221053@uk2.net

 · 

reply

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