| From: | Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> |
|---|---|
| To: | Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: updating remote database |
| Date: | 2004-02-26 09:51:30 |
| Message-ID: | 403DC1A2.9000506@scmbb.ulb.ac.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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,
Veuillez patienter...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Pips | 2004-02-26 09:51:41 | Field list from table |
| Previous Message | Richard Huxton | 2004-02-26 08:15:16 | Re: updating remote database |