| From: | tony <tony(at)animaproductions(dot)com> |
|---|---|
| To: | Alan <AlanJWayne(at)yahoo(dot)com> |
| Cc: | postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Help with data transfer please |
| Date: | 2002-06-11 06:54:05 |
| Message-ID: | 1023778446.23336.5.camel@vaio |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dev Rp | 2002-06-11 12:10:40 | indexes are not used |
| Previous Message | Achilleus Mantzios | 2002-06-11 06:44:32 | Re: [SQL] VIEWs and FOREIGN keys |