Re: updating remote database - Mailing list pgsql-sql

From Olivier Hubaut
Subject Re: updating remote database
Date
Msg-id 403DC1A2.9000506@scmbb.ulb.ac.be
Whole thread Raw
In response to updating remote database  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List 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...


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: updating remote database
Next
From: Achilleus Mantzios
Date:
Subject: Re: updating remote database