Re: Help with data transfer please

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