Re: Help with data transfer please

Hi!
I've been writing the interface via postgre-apache-php to use on the
internet. However, the "older" office, is very rural--no internet
connection. Telephone is about it. The application I've written would demand
almost constant telphone connection to the server for the front-office to
input/request data. Unfortunately, the offices are long distance from each
other. (And I'd hate to think what the cost of a special line would be).

Thanks,
ajw

----- Original Message -----
From: "tony" <tony(at)animaproductions(dot)com>
To: "Alan" <AlanJWayne(at)yahoo(dot)com>
Cc: "postgres list" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, June 11, 2002 1:54 AM
Subject: Re: [GENERAL] 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org