Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ED5389FBE84 for ; Mon, 2 Jul 2007 21:17:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78417-02-2 for ; Mon, 2 Jul 2007 21:17:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.236]) by postgresql.org (Postfix) with ESMTP id 91E329FBA90 for ; Mon, 2 Jul 2007 21:15:36 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 25so1041715wry for ; Mon, 02 Jul 2007 17:15:35 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=MGxOBFqfW8+2taisjmbpa3eG9zNxh5+EDzGGpOgDflOoD9rL1W0u8gkcXiXFFRwrBJCWs+fepDd++NufO37QdhOGSLUajlEO0Sw2Q0ska5Dw60KtQZwTg6Bg2jIfsh7LyAJUUW7Zsctn22hU2mOoZTKwTaktyHNGx8kSMGR2yJ0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=aoAR7Y8SUc5mES6sUd8HxlyWItt7C/G9yDZcg4L9bcsUWmTFc8rIwU4IRKoat63wnm0LqTC5JobcUxvrpDPz2gShvfyQhwTB2FMopxUzwXg6O2CWIzij9KGrbCenIOowUje4Gocv/YS+ggo4P5jckBKXGmUIi/NOImYKBMALxIk= Received: by 10.90.118.12 with SMTP id q12mr5689734agc.1183421735347; Mon, 02 Jul 2007 17:15:35 -0700 (PDT) Received: by 10.90.104.4 with HTTP; Mon, 2 Jul 2007 17:15:35 -0700 (PDT) Message-ID: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com> Date: Tue, 3 Jul 2007 08:15:35 +0800 From: "Yuan HOng" To: pgsql-admin Subject: Help me find a suitable replication solution MIME-Version: 1.0 Content-Type: text/plain; charset=GB2312; format=flowed Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.493 tagged_above=0 required=5 tests=AWL=0.548, BAYES_50=0.001, MIME_BASE64_NO_NAME=0.224, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200707/36 X-Sequence-Number: 26017 U29ycnkgSSBmb3Jnb3QgdGhlIHN1YmplY3QuCgpIaSwgbGlzdCwKCkNhbiB5b3UgZ2l2ZSBtZSBz b21lIHN1Z2dlc3Rpb25zIGFzIHRvIHdoYXQgcmVwbGljYXRpb24gc29sdXRpb24gYmVzdApzdWl0 cyBteSBzaXR1YXRpb246CgpJIGhhdmUgYW4gb25saW5lIHByb2R1Y3Qgc2FsZXMgYXBwbGljYWl0 b24sIHdoaWNoIGlzIHNwbGl0IGJldHdlZW4gdHdvCnNpdGVzLiBUaGUgd2ViIGZyb250LWVuZCBz aXRzIGF0IHRoZSBJU1AncyBkYXRhIGNlbnRlciBhbmQgYWNjZXB0cwpjdXN0b21lciBvcmRlci4g VGhlIHNlcnZlciBpbiB0aGUgb2ZmaWNlIGhhbmRsZXMgdGhlIHByb2R1Y3QgbGlzaXRuZywKb3Jk ZXIgcHJvY2Vzc2luZyBhbmQgYWxzbyB0YWtlcyBvcmRyZXMgb24gdGVsZXBob25lLiBUaGUgdHdv IHNpdGVzIGFyZQpsaW5rZWQgb3ZlciBJbnRlcm5ldCB1c2luZyBBRFNMLCBpLmUuIG5vdCBoaWdo IGJhbmR3aWR0aC4gRHVlIHRvIGhpZ2gKSW50ZXJuZXQgY29zdCBoZXJlLCBpdCB3b3VsZCBiZSBp bmZlYXNpYmxlIHRvIG1vdmUgdGhlIHR3byBzZXJ2ZXJzCnRvZ2V0aGVyLgoKRm9yIHRoZSBwcm9k dWN0aW9uIGluZm9ybWF0aW9uIHRhYmxlcywgdGhleSB3aWxsIGJlIHNvbGVseSBtYWludGFpbmVk CmluaG91c2UsIGFuZCB3aWxsIGJlIHN5bmNlZCB0byB0aGUgd2ViIHNlcnZlci4gSSBoYXZlIGJl ZW4gdXNpbmcKU2xvbnktSSBmb3IgdGhpcy4gQnV0IGZvciBvcmRyZSBhbmQgY3VzdG9tZXIgaW5m b3JtYXRpb24sIHNpbmNlIGJvdGgKc2l0ZXMgc2hhbGwgdXBkYXRlIHRoZXNlIHRhYmxlcywgYW5k IHRoZSBsaW5rIGlzIG92ZXIgYSBXQU4sIGl0IHNlZW1zCnRoZSBtb3N0IGFwcHJvcHJpYXRlIHJl cGxpY2F0aW9uIHNvbHV0aW9uIHdvdWxkIGJlIGEgbXVsdGktbWFzdGVyLAphc3luY2hyb25vdXMg c29sdXRpb24uCgpJIGhhdmUgZG9uZSBhIHF1aWNrIHJlc2VhcmNoIG9uIHRoZSBjdXJyZW50IFBv c3RncmVTUUwgcmVwbGljYXRpb24Kc29sdXRpb25zOiBTbG9ueS1JLCBQR1Bvb2woLUkgYW5kIC1J SSksIFBHQ2x1c3RlciwgYW5kIG5vbmUgb2YgdGhlbQpzZWVtcyB0byBmaXQgZXhhY3RseSBteSBz aXR1YWl0b246CgpTbG9ueS1JIGlzIG9ubHkgc2luZ2xlIG1hc3Rlci4gVGhlIG9ubHkgcG9zc2li bGUgd2F5IHRvIHVzZSBpdCB3b3VsZApiZSB0byB1c2UgYSBzZXBhcmF0ZSB0YWJsZSBmb3Igb3Jk ZXIgb24gd2ViIHNlcnZlciBhbmQgcmVwbGljYXRlIGl0CmJhY2sgdG8gaW5ob3VzZSBzZXJ2ZXIu IEJ1dCB0aGVuIEkgaGF2ZSB0d28gdGFibGVzIGZvciBvcmRlciwgd2hpY2gKd2lsbCBtYWtlIHRo ZSBhcHBsaWNhdGUgbXVjaCBjb21wbGljYXRlZC4KClBHUG9vbCBpcyB1c2VkIHByaW1hcmlseSBm b3IgY29ubmVjdGlvbiBwb29sbGluZy4gSXQgY2FuIGRvCnN5bmNocm9ub3VzIHJlcGxpY2F0aW9u IG9uIGRhdGFiYXNlIGxldmVsIGJ5IHNlbmRpbmcgdGhlIFNRTCBjb21tYW5kcwp0byAyIHNlcnZl cnMuIEJ1dCBzaW5jZSB0aGUgV0FOIGNvbm5lY3Rpb24gaXMgbm90IHN0YWJsZSwgaWYgdGhlCmNv bm5lY3Rpb24gaXMgZG93biBmb3IgYSB3aGlsZSwgdGhlIHJlcGxpY2F0aW9uIHdpbGwgYmUgYnJv a2VuIGFuZCBJCmRvbid0IHRoaW5rIFBHUG9vbCBjYW4gcmVzeW5jIHRoZSB0d28gZGF0YWJhc2Vz IGF1dG9tYXRpY2FsbHkuCgpQR0NsdXN0ZXIgaXMgc2ltaWxhciB0byBQR1Bvb2wgaW4gYmVpbmcg YSBzeW5jaHJvbm91cyByZXBsaWNhdGlvbgpzb2x1dGlvbi4gSSB0aGlua3MgaXQgd291bGQgb25s eSBiZSB1c2VmdWwgZm9yIGEgTEFOIHNpdHVhdGlvbi4gT3ZlciBhCldBTiwgaWYgdGhlIGxpbmsg aXMgYnJva2VuLCBJIHRoaW5rIGl0IHdvdWxkIGFsc28gYmUgaW1wb3NzaWJsZSBmb3IgaXQKdG8g cmVzdW1lIHJlcGxpY2F0aW9uLiBBbHNvLCBpdCBzZWVtcyBJIGNhbiBvbmx5IHJlcGxpY2F0ZSB0 aGUgd2hvbGUKZGF0YWJhc2UsIG5vdCB0aGUgc2VsZWN0ZWQgdGFibGVzLgoKRmluZGluZyBubyBz dWl0YWJsZSBzb2x1aXRvbiBmb3IgbXkgY2FzZSwgSSBhbSB3b25kZXJpbmcgd2hldGhlciBJCmhh dmUgbWFkZSBhIG1pc3Rha2UgaW4gbXkgZGF0YWJhc2UgZGVzaWduLiBIYXZlbnQnIG90aGVycyBl eHBlcmllbmNlZApzaW1pbGlhciBzaXR1YXRpb24gYXMgSSBkbz8gT3IgZG8gSSBoYXZlIHNvbWUg bWlzdW5kZXJzdGFuZGluZyBvZiB0aGUKY2FwYWJpbGl0aWVzIG9mIHRoZSBleGlzdGluZyBzb2x1 dGlvbnM/IEFtIEkgb3Zlcmxvb2tpbmcgc29tZXRoaW5nPwoKSXQgc2VlbXMgU2xvbnktSUkgd291 bGQgYmUgcXVpdGUgcHJvbWlzaW5nLCBidXQgSSBjYW4ndCB3YWl0IHRoYXQKbG9uZy4gV2hhdCBp cyB0aGUgYmVzdCBjaG9pY2UgZm9yIG1lIG5vdz8KClRoYW5rcyBmb3IgaGVscGluZyEKCi0tCkhv bmcgWXVhbgoKtPO53LzSzfjJz72ossSzrMrQCtew0N7XsOTqvaiyxNK71b7Kvbm6zu8KaHR0cDov L3d3dy5ob21lbWFzdGVyLmNuCg==