Kenneth Gonsalves wrote:
> i have a database on a local machine, and another on a remote machine. I have
> a dialup connection between the two - so band width is a problem. What is the
> most efficient way of updating the remote from the local? Does SQL or
> postgres have simple commands for this?
Is the remote database a clone of the local one? In this case, rsync
seems to me to be the faster method to do this, but you need to stop the
two databases before doing this.
Signature en cours de maintenance,
In response to
pgsql-sql by date
|Next:||From: Jan Pips||Date: 2004-02-26 09:51:41|
|Subject: Field list from table|
|Previous:||From: Richard Huxton||Date: 2004-02-26 08:15:16|
|Subject: Re: updating remote database|