Re: Help with data transfer please - Mailing list pgsql-general

Hi!

Where do I find rsync? I'm quite new to the language, what is Postgres-R?

I  have no problem shutting down the postmaster at night to do whatever is
necessary. I do have a laptap which I do most of my programming on,
however, I fail to see how I can keep differenct machines in sync with each
machine having its own version of the sequence files used for unique record
id's.

Without yet knowing rsync, my first thought was to write a program that
would capture
insert and updates (after the fact) and a second program that would
essentially add or
modify the needed records at the second machine using user specific data as
candidate keys.
It would sure be great if there was already something out there to do this,
or that could
correctly keep all the sequences in sync! I have no desire to reinvent the
wheel, but will do
whatever is necessary.

Thanks!
ajw


----- Original Message -----
From: "Andrew Sullivan" <andrew@libertyrms.info>
To: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Monday, June 10, 2002 10:42 AM
Subject: Re: [GENERAL] 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@libertyrms.info>                              M6K 3E3
>                                          +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org