X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 67036D1CA83 for ; Thu, 26 Feb 2004 09:51:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55116-02 for ; Thu, 26 Feb 2004 05:51:41 -0400 (AST) Received: from bonito.ulb.ac.be (mailhost.ulb.ac.be [164.15.59.220]) by svr1.postgresql.org (Postfix) with ESMTP id B6994D1B903 for ; Thu, 26 Feb 2004 05:51:37 -0400 (AST) Received: from mach.vub.ac.be (mach.ulb.ac.be [164.15.128.3]) by bonito.ulb.ac.be (8.8.8/3.17.1.ap (resu)) id KAA10235; Thu, 26 Feb 2004 10:50:43 +0100 (MET) for Received: from scmbb.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (8.9.3/3.13.5.aejp (mach)) id KAA24830; Thu, 26 Feb 2004 10:51:33 +0100 (MET) for Message-ID: <403DC1A2.9000506@scmbb.ulb.ac.be> Date: Thu, 26 Feb 2004 10:51:30 +0100 From: Olivier Hubaut User-Agent: Mozilla Thunderbird 0.5 (Macintosh/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kenneth Gonsalves Cc: pgsql-sql@postgresql.org Subject: Re: updating remote database References: <04022608245506.01440@thenilgiris.com> In-Reply-To: <04022608245506.01440@thenilgiris.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/360 X-Sequence-Number: 17050 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...