On Tue, 2002-06-11 at 04:37, Alan wrote:
> 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" ?
Secure shell and secure copy. They replace telnet and cp.
> Can pg_dump be used to do this?
>
> What would you think about dumping the database to a read/write CD?
Yes this is a good idea. Mount your CD-RW and do a pg_dump to the
mounted disk.
Remember that you need to drop the database and do a restore from the
dump file each time.
I missed your first post. Why do you have high long distance charges? I
would have the database in one location and access it from the distant
site. Maybe through a web front end.
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