Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0715864FCE3 for ; Thu, 11 Sep 2008 01:39:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66563-02 for ; Thu, 11 Sep 2008 01:39:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.232]) by postgresql.org (Postfix) with ESMTP id F1D6C64FCD2 for ; Thu, 11 Sep 2008 01:39:12 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so217160rvf.43 for ; Wed, 10 Sep 2008 21:39:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=xEPo3h3Lym6ArFIhlmj8WGQ2m5WIaO4L75nPauiLuHw=; b=SS33q7zrmosX9MxxXXDhjnj31cURdkftOrVd16FZ7D5C+EZRkv22omyvXH922pmTeC xpHSGFtRB567SC3r48GWWD0S3vKbJV+7iNULkceRHABTT1NjQ2KWQcuD17eY8ULdrFm7 pKZya1/Mm+DTZWDZ6Lm2w8xIQJn3nnwAor51w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=gWTcahQujgv8wftYNkW7UZdgDm/5uoZ2mWNMYmn/o9vEVyRUXrtMJ4H0XBaMfXh2Xe P1fncx7k4l7aiG9v3Wpe3QBLz9p2gOCQ3rMrZh7TgJRH+IrLMgwZx+mimRBbhpeMwNPo SrbkmLQ5qoYFRKWT1Ksd2a88ZfiO6GyaNnZdc= Received: by 10.140.226.14 with SMTP id y14mr1421534rvg.123.1221107950797; Wed, 10 Sep 2008 21:39:10 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Wed, 10 Sep 2008 21:39:10 -0700 (PDT) Message-ID: Date: Wed, 10 Sep 2008 22:39:10 -0600 From: "Scott Marlowe" To: "Aftab Alam" Subject: Re: sync of db Cc: "pgsql-admin@postgresql.org" In-Reply-To: <127B4898CB0EE64DA86CDB35C6713FB503000C0BD7@tsr-exch03> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <127B4898CB0EE64DA86CDB35C6713FB503000C0BD7@tsr-exch03> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/89 X-Sequence-Number: 30182 On Wed, Sep 10, 2008 at 10:13 PM, Aftab Alam wrote: > Hi all, As mentioned slony might be a good choice. One of the nice features is that you can disconnect the network cable from source to destination and plug it back in a few minutes later and it will just catch up without too much complaint. And it's features for switching out dbs and sch are quite nice.