Re: Help with data transfer please

Hi!

This sounds plausible and may very well be the solution. Sorry for my
ignorance, I know next to nothing about unix/linux scripts. What is
"SSH" and "SCP" ?

Can pg_dump be used to do this?

What would you think about dumping the database to a read/write CD?

Thanks,
ajw

----- Original Message -----
From: "tony" <tony(at)animaproductions(dot)com>
To: "Andrew Sullivan" <andrew(at)libertyrms(dot)info>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Monday, June 10, 2002 1:40 PM
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