Re: Help with data transfer please

Hey, don't forget:

His original problem was sometimes updating the dbase from the home site,
sometimes updating it from the remote site.

You cron job sounds like it always pushes the dbase to the remote site (or
vice versa).

You would need to make the script more complex so it decides if the version
received has newer data then the one it currently has, and only clobber the
dbase if newer.

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of tony
> Sent: Monday, June 10, 2002 2:41 PM
> To: Andrew Sullivan
> Cc: pgsql-general
> Subject: Re: [GENERAL] Help with data transfer please
>
>
> On Mon, 2002-06-10 at 17:42, Andrew Sullivan wrote:
>
> > 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.
>
> Good idea
>
> > 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.)
>
> SSH is your friend!
>
> Set up a cron job that dumps the database.
> SCP the dump from one machine to the other.
> Drop the database and recreate it.
> Import the dump file.
>
> This is the system I will be putting into place for a client in
> september. For another with non sensitive data the dump is e-mailed
> daily as a backup. Just got to love aDSL!!
>
> Cheers
>
> Tony Grant
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia UltraDev with PostgreSQL
> http://www.animaproductions.com/ultra.html
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>