Skip site navigation (1) Skip section navigation (2)

Re: updating remote database

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 (view raw or flat)
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...

In response to

pgsql-sql by date

Next:From: Jan PipsDate: 2004-02-26 09:51:41
Subject: Field list from table
Previous:From: Richard HuxtonDate: 2004-02-26 08:15:16
Subject: Re: updating remote database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group