Re: Help with data transfer please

On Sun, Jun 09, 2002 at 12:52:04PM -0500, Gunther Schadow wrote:
> Alan, you may want to look into the contrib subdirectory.
> I have seen some gizmo there that promises to do replication.
> It seems to be using triggers etc. as you suggest. See
> either in the source tree or if you don't have it around
> but have installed the contrib stuff, all the readmes are
> installed too, so you should find it.

I I understand his need correctly, what is needed is a two-way sync:
changes in office 1 need to be in office 2 for when he goes to office
2, and then changes made at office 2 need to get sent back to office
1. If I'm right, rserv won't work. Recent discussions of
replication did not, IIRC, turn up any multi-master replication
systems other than Postgres-R. (Maybe I don't RC, though.)

One answer might be to buy a laptop. Carry the database in the
laptop. It's another expense, of course, but it might work.

Alternatively, since the database can (presumably) be shut down every
night, why not shut down the postmaster at each end and use rsync to
synchronise the data directories? (I haven't tested that, and don't
know if it'll work, but I think it should.)

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110