Re: 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