Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwTA1-0004SW-Tc for pgsql-admin@arkaria.postgresql.org; Fri, 07 Apr 2017 12:38:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwTA1-0004CJ-Fv for pgsql-admin@arkaria.postgresql.org; Fri, 07 Apr 2017 12:38:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwT8E-00012B-RV for pgsql-admin@postgresql.org; Fri, 07 Apr 2017 12:36:50 +0000 Received: from mail-pg0-x241.google.com ([2607:f8b0:400e:c05::241]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cwT8B-0000PQ-CJ for pgsql-admin@postgresql.org; Fri, 07 Apr 2017 12:36:49 +0000 Received: by mail-pg0-x241.google.com with SMTP id g2so15293183pge.2 for ; Fri, 07 Apr 2017 05:36:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=message-id:date:subject:importance:from:to:mime-version; bh=GIX9olHHmVCZPgNgkw+X1qnFS5CFlpBGE8vUwGElvCM=; b=SpspkzuYvd96uHIS5PS9WSL0XL0gtIh4aGR7a410tJya0s2so6+9lmRWdR7hdMBGAo 652iytc6lRux3oFsvYZYVC1g2bInPj2Nd7wLH2N7puBjsPUFC8mq5Xi4QtA4udTYoupH liB3sR9AxCHeb/q6V1BNdslFSa51WDf4D83dpvJYU6nwCFxiX/sXxO56D6LrgLlCRB/B 12zJdH222fz56PWdXUhZVhcU0RZEUJK6Lv7kuDN5Rqm0TrW9zjvoY2T+/vlKRwW+kzY4 9a/i++4+rY+IeoYQ+rN0mrXR07qXfA48Qkwk5V21tnTtE3B5SFvjD4SkErAG5zXxMjQG 4kIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:date:subject:importance:from:to :mime-version; bh=GIX9olHHmVCZPgNgkw+X1qnFS5CFlpBGE8vUwGElvCM=; b=j1g2/wYtYHAB/OongA2uWnnDdXUzhnnxfIGxvufVOsQrp9l6qpLm2YMAUIcJWYdIeD nEgPCuMlW1RfM80U4CciOwOxDqttFkiNpO0aEtFfU9mQCUKqhcvmWuF0bY4+WuJD0M8O r6Nln+I5hj97NvC1gvsLrB52jUJtsG538jr/daxgIzBEkeGArP+AJIc/4mk7YkdRzA97 S2RZzBIMZJ/RQ/isRkeMR2f2NUqqhY/DP/PMgkIpl/zYlp25eDRFoA0mf0/lx267APNJ 3JOcNpbg6AYXWhkwhC1ebHefKbfCGUK+i3cb+jrW62/nQQpYex4JfyIAPa40CK0tPpzA dl+g== X-Gm-Message-State: AFeK/H3P/h7ajGVFW625v5FhgYA9nyMmShsWa7877TGyfyZAvpVskhZJCFkINicUARX1wQ== X-Received: by 10.98.82.204 with SMTP id g195mr40748942pfb.28.1491568605954; Fri, 07 Apr 2017 05:36:45 -0700 (PDT) Received: from [192.168.1.11] (36-231-188-251.dynamic.hinet.net. [36.231.188.251]) by smtp.gmail.com with ESMTPSA id c9sm3639712pfk.90.2017.04.07.05.36.44 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 07 Apr 2017 05:36:45 -0700 (PDT) Message-ID: <58e787dd.8995620a.866c2.6c67@mx.google.com> Date: Fri, 07 Apr 2017 20:36:40 +0800 Subject: Re: How do you manage cluster replication and failover ? Importance: normal From: stevenchang1213 To: Robin LUCBERNET , "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--_com.samsung.android.email_22981711110510" X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ----_com.samsung.android.email_22981711110510 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 CmhpIHJvYmluLArCoCDCoCDCoCBBbGwgdXIgd29yZHMgaXMganVzdCBvbmUgdGhpbmcgLSBwZ3Bv b2wgSUkuwqAgwqAgwqBUaGUgcHJvamVjdCBhbHNvIGNvbnRhaW5zIEFkbWluIFVJLsKgIMKgIMKg IFUgY2FuIGRvd25sb2FkIGFuZCB0cnkgaXQuCnN0ZXZlbsKgCi0tLS0tLS0tIOWOn+Wni+ioiuaB ryAtLS0tLS0tLeiHqu+8miBSb2JpbiBMVUNCRVJORVQgPHJsdWNiZXJuZXRAbWFsdGVtLmNvbT4g 5pel5pyf77yaIDIwMTcvNC82ICAxNzoxNyAgKEdNVCswODowMCkg6Iez77yaIHBnc3FsLWFkbWlu QHBvc3RncmVzcWwub3JnIOS4u+aXqO+8miBbQURNSU5dIEhvdyBkbyB5b3UgbWFuYWdlIGNsdXN0 ZXIgcmVwbGljYXRpb24gYW5kIGZhaWxvdmVyID8gCgoKSGVsbG8sCgoKCldlIGFyZSBjdXJyZW50 bHkgdHJ5aW5nIHRvIHNldHVwIGEgbXVsdGkgaG9zdHMgZGF0YWJhc2VzIGNsdXN0ZXIgd2l0aCBn b2FsczoKCsKgKiByZXBsaWNhdGlvbiAobm8gZGF0YS1sb3NzIGlzICJyZXF1aXJlZCIsIHJlcGxp Y2F0aW9uIHRpbWluZyBkbyBub3QgbmVlZHMgdG8gYmUgaW5zdGFudCkKCsKgKiBmYWlsb3ZlcgoK wqAqIGxvYWQtYmFsYW5jaW5nIChib251cykKCgoKV2UgdHJpZWQ6CgrCoCogc3luY2hyb25pb3Vz IHJlcGxpY2F0aW9uIChwZ3Bvb2wgcmVwbGljYXRpb24gbW9kZSkgKyBsb2FkLWJhbGFuY2luZyAo cGdwb29sKSA6IHZlcnkgaW50ZXJlc2luZyBhcyB3ZSBjYW4gdGhlb3JpY2FsbHkgZmFpbG92ZXIg b24gYW55IG5vZGUgYXQgYW55IG1vbWVudC4gQnV0IGV2ZW4gYWZ0ZXIgc2V2ZXJhbCBjb25maWd1 cmFhdGlvbiB0d2Vla3MsIHdlIG5ldmVyIHN1Y2NlZWQgZ2V0dGluZyBnb29kIHdyaXRlIHBlcmZv cm1hbmNlLgoKwqAqIGFzeW5jaHJvbmlvdXMgcmVwbGljYXRpb24gKHBvc3RncmVzIDkuNiBzdHJl YW1pbmcgcmVwbGljYXRpb24pIDogZ29vZCB3cml0ZSBwZXJmb3JtYW5jZSwgZ29vZCByZXBsaWNh dGlvbiB0aW1pbmdzICg8IDEgc2Vjb25kIGZvciBzbWFsbCB0cmFuc2FjdGlvbnMpLiBXZSBjb3Vs ZCBsb2FkYmFsYW5jZSBzZWxlY3QgcmVxdWVzdHMgdXNpbmcgcGdwb29sLgoKCgoKCkhvdyBkbyB5 b3UgbWFuYWdlIHlvdXIgcG9zdGdyZXNxbCBjbHVzdGVycyA/IERvIHlvdSB1c2UgcGdwb29sID8g cGdib3VuY2VyID8gb3RoZXIgPwoKSG93IGRvIHlvdSBtYW5hZ2UgdG8gc2luZ2xlIGFjY2VzcyBw b2ludCA/IHVzaWduIHBncG9vbCA/IHBnYm91bmNlciA/CgpEbyB5b3UgdXNlIHN0cmVhbWluZyBy ZXBsaWNhdGlvbiA/IFdBTCBhcmNoaXZpbmcgPyBIb3cgZG8geW91IGhhbmRsZSB0byBhdXRvbWF0 aWMgZmFpbG92ZXIgPwoKCgpSb2JpbgoKCgo= ----_com.samsung.android.email_22981711110510 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keT48ZGl2Pjxicj48L2Rpdj48ZGl2Pmhp IHJvYmluLDwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgQWxs IHVyIHdvcmRzIGlzIGp1c3Qgb25lIHRoaW5nIC0gcGdwb29sIElJLjwvZGl2PjxkaXY+Jm5ic3A7 ICZuYnNwOyAmbmJzcDtUaGUgcHJvamVjdCBhbHNvIGNvbnRhaW5zIEFkbWluIFVJLjwvZGl2Pjxk aXY+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgVSBjYW4gZG93bmxvYWQgYW5kIHRyeSBpdC48L2Rpdj48 ZGl2Pjxicj48L2Rpdj48ZGl2PnN0ZXZlbiZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXYg c3R5bGU9ImZvbnQtc2l6ZToxMDAlO2NvbG9yOiMwMDAwMDAiPjwhLS0gb3JpZ2luYWxNZXNzYWdl IC0tPjxkaXY+LS0tLS0tLS0g5Y6f5aeL6KiK5oGvIC0tLS0tLS0tPC9kaXY+PGRpdj7oh6rvvJog Um9iaW4gTFVDQkVSTkVUICZsdDtybHVjYmVybmV0QG1hbHRlbS5jb20mZ3Q7IDwvZGl2PjxkaXY+ 5pel5pyf77yaIDIwMTcvNC82ICAxNzoxNyAgKEdNVCswODowMCkgPC9kaXY+PGRpdj7oh7PvvJog cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcgPC9kaXY+PGRpdj7kuLvml6jvvJogW0FETUlOXSBI b3cgZG8geW91IG1hbmFnZSBjbHVzdGVyIHJlcGxpY2F0aW9uIGFuZCBmYWlsb3ZlciA/IDwvZGl2 PjxkaXY+PGJyPjwvZGl2PjwvZGl2Pgo8ZGl2IGlkPSJkaXZ0YWdkZWZhdWx0d3JhcHBlciIgc3R5 bGU9ImZvbnQtc2l6ZToxMnB0O2NvbG9yOiMwMDAwMDA7Zm9udC1mYW1pbHk6Q2FsaWJyaSxBcmlh bCxIZWx2ZXRpY2Esc2Fucy1zZXJpZjsiIGRpcj0ibHRyIj4KPHA+PHNwYW4gY2xhc3M9Im1lc3Nh Z2VfYm9keSI+SGVsbG8sPC9zcGFuPjwvcD4KPHA+PHNwYW4gY2xhc3M9Im1lc3NhZ2VfYm9keSI+ PGJyPgo8L3NwYW4+PC9wPgo8cD48c3BhbiBjbGFzcz0ibWVzc2FnZV9ib2R5Ij48c3BhbiBjbGFz cz0icGFyYV9icmVhayI+PC9zcGFuPjwvc3Bhbj48c3BhbiBjbGFzcz0ibWVzc2FnZV9ib2R5Ij5X ZSBhcmUgY3VycmVudGx5IHRyeWluZyB0byBzZXR1cCBhIG11bHRpIGhvc3RzIGRhdGFiYXNlcyBj bHVzdGVyIHdpdGggZ29hbHM6PGJyPgombmJzcDsqIHJlcGxpY2F0aW9uIChubyBkYXRhLWxvc3Mg aXMgInJlcXVpcmVkIiwgcmVwbGljYXRpb24gdGltaW5nIGRvIG5vdCBuZWVkcyB0byBiZSBpbnN0 YW50KTxicj4KJm5ic3A7KiBmYWlsb3Zlcjxicj4KJm5ic3A7KiBsb2FkLWJhbGFuY2luZyAoYm9u dXMpPC9zcGFuPjwvcD4KPHA+PHNwYW4gY2xhc3M9Im1lc3NhZ2VfYm9keSI+PGJyPgo8L3NwYW4+ PC9wPgo8cD48c3BhbiBjbGFzcz0ibWVzc2FnZV9ib2R5Ij48c3BhbiBjbGFzcz0icGFyYV9icmVh ayI+PC9zcGFuPjwvc3Bhbj48c3BhbiBjbGFzcz0ibWVzc2FnZV9ib2R5Ij5XZSB0cmllZDo8YnI+ CiZuYnNwOyogc3luY2hyb25pb3VzIHJlcGxpY2F0aW9uIChwZ3Bvb2wgcmVwbGljYXRpb24gbW9k ZSkgKyBsb2FkLWJhbGFuY2luZyAocGdwb29sKSA6IHZlcnkgaW50ZXJlc2luZyBhcyB3ZSBjYW4g dGhlb3JpY2FsbHkgZmFpbG92ZXIgb24gYW55IG5vZGUgYXQgYW55IG1vbWVudC4gQnV0IGV2ZW4g YWZ0ZXIgc2V2ZXJhbCBjb25maWd1cmFhdGlvbiB0d2Vla3MsIHdlIG5ldmVyIHN1Y2NlZWQgZ2V0 dGluZyBnb29kIHdyaXRlIHBlcmZvcm1hbmNlLjxicj4KJm5ic3A7KiBhc3luY2hyb25pb3VzIHJl cGxpY2F0aW9uIChwb3N0Z3JlcyA5LjYgc3RyZWFtaW5nIHJlcGxpY2F0aW9uKSA6IGdvb2Qgd3Jp dGUgcGVyZm9ybWFuY2UsIGdvb2QgcmVwbGljYXRpb24gdGltaW5ncyAoJmx0OyAxIHNlY29uZCBm b3Igc21hbGwgdHJhbnNhY3Rpb25zKS4gV2UgY291bGQgbG9hZGJhbGFuY2Ugc2VsZWN0IHJlcXVl c3RzIHVzaW5nIHBncG9vbC48c3BhbiBjbGFzcz0icGFyYV9icmVhayI+PC9zcGFuPjwvc3Bhbj48 c3BhbiBjbGFzcz0ibWVzc2FnZV9ib2R5Ij48YnI+Cjwvc3Bhbj48L3A+CjxwPjxzcGFuIGNsYXNz PSJtZXNzYWdlX2JvZHkiPjxicj4KPC9zcGFuPjwvcD4KPHA+PHNwYW4gY2xhc3M9Im1lc3NhZ2Vf Ym9keSI+SG93IGRvIHlvdSBtYW5hZ2UgeW91ciBwb3N0Z3Jlc3FsIGNsdXN0ZXJzID8gRG8geW91 IHVzZSBwZ3Bvb2wgPyBwZ2JvdW5jZXIgPyBvdGhlciA/PGJyPgpIb3cgZG8geW91IG1hbmFnZSB0 byBzaW5nbGUgYWNjZXNzIHBvaW50ID8gdXNpZ24gcGdwb29sID8gcGdib3VuY2VyID88YnI+CkRv IHlvdSB1c2Ugc3RyZWFtaW5nIHJlcGxpY2F0aW9uID8gV0FMIGFyY2hpdmluZyA/IEhvdyBkbyB5 b3UgaGFuZGxlIHRvIGF1dG9tYXRpYyBmYWlsb3ZlciA/PC9zcGFuPjwvcD4KPHA+PHNwYW4gY2xh c3M9Im1lc3NhZ2VfYm9keSI+PGJyPgo8L3NwYW4+PC9wPgo8cD48c3BhbiBjbGFzcz0ibWVzc2Fn ZV9ib2R5Ij5Sb2Jpbjwvc3Bhbj48YnI+CjwvcD4KPC9kaXY+CjwvYm9keT48L2h0bWw+ ----_com.samsung.android.email_22981711110510--