Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dqD8r-0008Rk-My for pgsql-admin@arkaria.postgresql.org; Fri, 08 Sep 2017 06:51:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dqD8q-0001BP-7y for pgsql-admin@arkaria.postgresql.org; Fri, 08 Sep 2017 06:51:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dqD8p-0001B8-Ls for pgsql-admin@postgresql.org; Fri, 08 Sep 2017 06:51:51 +0000 Received: from forward5o.cmail.yandex.net ([37.9.109.249]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dqD8e-0005Yz-Qf for pgsql-admin@postgresql.org; Fri, 08 Sep 2017 06:51:51 +0000 Received: from mxback17j.mail.yandex.net (mxback17j.mail.yandex.net [IPv6:2a02:6b8:0:1619::93]) by forward5o.cmail.yandex.net (Yandex) with ESMTP id A90C521272; Fri, 8 Sep 2017 09:51:37 +0300 (MSK) Received: from web3g.yandex.ru (web3g.yandex.ru [95.108.252.103]) by mxback17j.mail.yandex.net (nwsmtp/Yandex) with ESMTP id aHTi8ulyJV-pZBOcjEk; Fri, 08 Sep 2017 09:51:36 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1504853496; bh=TI0h+BQTsI8Mj/oHWcwLd9kaznFBdShYu2eNVYWoH0Q=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=Tm8vBhwlIEzyRl/2YXA0+zBRdICRCRLmHhHXbEpl6HEiACMzO9b7/fRqu0dMbk7by /lku5qBvsleE0nuGotz6JnrUcyCU+qSH8TTpe5SuWbEOQXeTle4BwT0EJLwljYJTsv BCYkDlniPSvx2Fmup14pGfJ1JGoHtSnfEBJCQC7k= Authentication-Results: mxback17j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web3g.yandex.ru with HTTP; Fri, 08 Sep 2017 09:51:35 +0300 From: Samed YILDIRIM To: "pgsql-admin@postgresql.org" , Sunil N Shinde In-Reply-To: References: Subject: Re: postgres streaming replication for HA MIME-Version: 1.0 Message-Id: <28541504853495@web3g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 08 Sep 2017 09:51:35 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 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 SGkgU2hpbmRlLDxkaXY+PGJyIC8+PC9kaXY+PGRpdj5EbyB5b3UgdHJ5aW5nIHN3aXRob3ZlciBt YW51YWxseT8gT3IgZG8geW91IHVzZSBhbnkgbWFuYWdlciBvciBzY3JpcHQgdG8gaGFuZGxlIHN3 aXRjaG92ZXIgb3BlcmF0aW9uPzwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj5CZXN0IHJlZ2Fy ZHMuPC9kaXY+PGRpdj48YnIgLz4tLSA8YnIgLz5ZYW5kZXguTWFpbCBtb2JpbCB1eWd1bGFtYXPE sW5kYW4gZ8O2bmRlcmlsZGk8YnIgLz48YnIgLz4wODo1MSwgOCBFeWzDvGwgMjAxNywgU3VuaWwg TiBTaGluZGUgJmx0O3N1bmlsLnNoaW5kZUBtYXN0ZWsuY29tJmd0Ozo8YnIgLz48YmxvY2txdW90 ZT48YnIgLz48YnIgLz48YnIgLz48YnIgLz48YnIgLz48YnIgLz48ZGl2IGxhbmc9IkVOLUlOIiBs aW5rPSJibHVlIiB2bGluaz0icHVycGxlIj48YnIgLz48ZGl2PjxiciAvPjxwPkhpLDwvcD48YnIg Lz48cD7CoDwvcD48YnIgLz48cD5JIGFtIGZvcm1pbmcgMiBub2RlIGNsdXN0ZXIgb2Ygc3RyZWFt aW5nIHJlcGxpY2F0aW9uIGZvciBIQS4gSSBjb3VsZCBhYmxlIHRvIHN1Y2NlZWQgd2l0aCB0aGUg cmVwbGljYXRpb24gcHJvY2Vzcy48L3A+PGJyIC8+PHA+QnV0IEkgYW0gbm90IGFibGUgdG8gY29t cGxldGUgdGhlIOKAnDxiPnN3aXRjaG92ZXI8L2I+4oCdLiA8YnIgLz48L3A+PGJyIC8+PHA+wqA8 L3A+PGJyIC8+PHA+VmVyc2lvbiA6IHBvc3RncmVzcWwtOS42PC9wPjxiciAvPjxwPk9TIDpSSEVM NzwvcD48YnIgLz48cD7CoDwvcD48YnIgLz48cD5NYXN0ZXIgTm9kZSBQYXJhbWV0ZXJzOjwvcD48 YnIgLz48cD7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgPGk+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZTo5cHQ7Zm9udC1mYW1pbHk6Q2FtYnJpYSxzZXJpZjsiPndhbF9sZXZlbCA9 IGhvdF9zdGFuZGJ5wqA8YnIgLz48L3NwYW4+PC9pPjwvcD48YnIgLz48cD48aT48c3BhbiBzdHls ZT0iZm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+wqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBzeW5jaHJvbm91c19jb21taXQgPSBsb2NhbDwvc3Bh bj48L2k+PC9wPjxiciAvPjxwPjxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6OXB0O2ZvbnQtZmFt aWx5OkNhbWJyaWEsc2VyaWY7Ij7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg IGFyY2hpdmVfbW9kZSA9IG9uwqA8YnIgLz48L3NwYW4+PC9pPjwvcD48YnIgLz48cD48aT48c3Bh biBzdHlsZT0iZm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+wqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBhcmNoaXZlX2NvbW1hbmQgPSAnY3AgJXAg L3Zhci9saWIvcGdzcWwvOS42L2RhdGEvYXJjaGl2ZS8lZifCoMKgwqDCoMKgwqDCoMKgIMKgwqDC oMKgwqDCoMKgwqDCoMKgPGJyIC8+PC9zcGFuPjwvaT48L3A+PGJyIC8+PHA+PGk+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZTo5cHQ7Zm9udC1mYW1pbHk6Q2FtYnJpYSxzZXJpZjsiPsKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgbWF4X3dhbF9zZW5kZXJzID0gMjwvc3Bhbj48L2k+ PC9wPjxiciAvPjxwPjxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6OXB0O2ZvbnQtZmFtaWx5OkNh bWJyaWEsc2VyaWY7Ij7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHdhbF9r ZWVwX3NlZ21lbnRzID0gMTA8L3NwYW4+PC9pPjwvcD48YnIgLz48cD48aT48c3BhbiBzdHlsZT0i Zm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+wqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBzeW5jaHJvbm91c19zdGFuZGJ5X25hbWVzID0gJ1VXUEdS RUNMVVMyJzwvc3Bhbj48L2k+PC9wPjxiciAvPjxwPsKgPC9wPjxiciAvPjxwPsKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHBiX2hi YS5jb25mwqDCoMKgwqDCoCA8L3A+PGJyIC8+PHAgc3R5bGU9Im1hcmdpbi1sZWZ0OjU0cHQ7Ij48 aT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+ IyBMb2NhbGhvc3Q8L3NwYW4+PC9pPjwvcD48YnIgLz48cCBzdHlsZT0ibWFyZ2luLWxlZnQ6NzJw dDsiPjxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6OXB0O2ZvbnQtZmFtaWx5OkNhbWJyaWEsc2Vy aWY7Ij5ob3N0wqDCoMKgIHJlcGxpY2F0aW9uwqDCoMKgwqAgcmVwbGljYcKgwqDCoMKgwqDCoMKg wqDCoCAxMjcuMC4wLjEvMzLCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIG1kNcKgwqDCoMKgwqDCoMKg wqDCoMKgPGJyIC8+PC9zcGFuPjwvaT48L3A+PGJyIC8+PHAgc3R5bGU9Im1hcmdpbi1sZWZ0Ojcy cHQ7Ij48aT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNl cmlmOyI+IyBQb3N0Z3JlU1FMIE1hc3RlciBJUCBhZGRyZXNzPC9zcGFuPjwvaT48L3A+PGJyIC8+ PHAgc3R5bGU9Im1hcmdpbi1sZWZ0OjcycHQ7Ij48aT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjlw dDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+aG9zdMKgwqDCoCByZXBsaWNhdGlvbsKgwqDC oMKgIHJlcGxpY2HCoMKgwqDCoMKgwqDCoMKgwqAgMTAuMC4zLjQvMzLCoMKgwqDCoMKgwqDCoMKg wqDCoMKgIG1kNTwvc3Bhbj48L2k+PC9wPjxiciAvPjxwIHN0eWxlPSJtYXJnaW4tbGVmdDo3MnB0 OyI+PGk+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTo5cHQ7Zm9udC1mYW1pbHk6Q2FtYnJpYSxzZXJp ZjsiPiMgUG9zdGdyZVNRTCBTTGF2ZSBJUCBhZGRyZXNzPC9zcGFuPjwvaT48L3A+PGJyIC8+PHAg c3R5bGU9Im1hcmdpbi1sZWZ0OjcycHQ7Ij48aT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjlwdDtm b250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+aG9zdMKgwqDCoCByZXBsaWNhdGlvbsKgwqDCoMKg IHJlcGxpY2HCoMKgwqDCoMKgwqDCoMKgwqAgMTAuMC4zLjUvMzLCoMKgwqDCoMKgwqDCoMKgwqDC oMKgIG1kNTwvc3Bhbj48L2k+PC9wPjxiciAvPjxwPsKgPC9wPjxiciAvPjxwPlNsYXZlIE5vZGUg UGFyYW1ldGVyczo8L3A+PGJyIC8+PHA+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgIDxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6OXB0O2ZvbnQtZmFtaWx5OkNhbWJyaWEsc2Vy aWY7Ij53YWxfbGV2ZWwgPSBob3Rfc3RhbmRiecKgPGJyIC8+PC9zcGFuPjwvaT48L3A+PGJyIC8+ PHA+PGk+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTo5cHQ7Zm9udC1mYW1pbHk6Q2FtYnJpYSxzZXJp ZjsiPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgc3luY2hyb25vdXNfY29t bWl0ID0gbG9jYWw8L3NwYW4+PC9pPjwvcD48YnIgLz48cD48aT48c3BhbiBzdHlsZT0iZm9udC1z aXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlmOyI+wqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoCBtYXhfd2FsX3NlbmRlcnMgPSAyPC9zcGFuPjwvaT48L3A+PGJyIC8+ PHA+PGk+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTo5cHQ7Zm9udC1mYW1pbHk6Q2FtYnJpYSxzZXJp ZjsiPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgd2FsX2tlZXBfc2VnbWVu dHMgPSAxMDwvc3Bhbj48L2k+PC9wPjxiciAvPjxwPjxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6 OXB0O2ZvbnQtZmFtaWx5OkNhbWJyaWEsc2VyaWY7Ij7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgIHN5bmNocm9ub3VzX3N0YW5kYnlfbmFtZXMgPSAnVVdQR1JFQ0xVUzInPC9z cGFuPjwvaT48L3A+PGJyIC8+PHA+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oCA8aT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjlwdDtmb250LWZhbWlseTpDYW1icmlhLHNlcmlm OyI+aG90X3N0YW5kYnkgPSBvbjwvc3Bhbj48L2k+PC9wPjxiciAvPjxwPsKgPC9wPjxiciAvPjxw PjwvcD48YnIgLz48cD48Yj5SZXBsaWNhdGlvbiBpcyBwcm9wZXJseSBoYXBwZW5pbmcgZnJvbSBt YXN0ZXIgdG8gc2xhdmUuIEJ1dCBJIGFtIG5vdCBhYmxlIHRvIHN3aXRjaG92ZXIgYmV0d2VlbiB0 aGUgbm9kZXMuPC9iPjwvcD48YnIgLz48cD7CoDwvcD48YnIgLz48cD5DYW4gYW55b25lIHBsZWFz ZSBndWlkZSBtZSBpbiB0aGlzIHJlZ2FyZD88L3A+PGJyIC8+PHA+wqA8L3A+PGJyIC8+PHA+wqA8 L3A+PGJyIC8+PHA+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMHB0O2NvbG9yOiMwMDQwODA7Ij5U aGFua3MgJmFtcDsgUmVnYXJkcyw8L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB0O2Zv bnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyxzZXJpZjsiPjxiciAvPjxiciAv PjxiciAvPjwvc3Bhbj48Yj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7VHJlYnVjaGV0IE1TJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzAwNDA4MDsiPlN1bmls IE4gU2hpbmRlPC9zcGFuPjwvYj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEycHQ7Zm9udC1mYW1p bHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LHNlcmlmOyI+PGJyIC8+PGJyIC8+PGJyIC8+ PC9zcGFuPjxiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTBwdDtmb250LWZhbWlseTomcXVvdDtU cmVidWNoZXQgTVMmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMDA0MDgwOyI+QXNzaXN0YW50IE1h bmFnZXIg4oCTIERCQTwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB0O2ZvbnQt ZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyxzZXJpZjsiPjxiciAvPjxiciAvPjxi ciAvPjwvc3Bhbj48Yj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwcHQ7Zm9udC1mYW1pbHk6JnF1 b3Q7VHJlYnVjaGV0IE1TJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzAwNDA4MDsiPk1hc3RlayBM dGQgfCBNYXN0ZWsgTWlsbGVubml1bSBDZW50ZXIsIE1pbGxlbm5pdW0gQnVzaW5lc3MgUGFyaywg TWFoYXBlLCBOYXZpIE11bWJhaS00MDA3MTAgLjwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImZvbnQt c2l6ZToxMnB0O2ZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyxzZXJpZjsi PjxiciAvPjxiciAvPjxiciAvPjwvc3Bhbj48Yj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwcHQ7 Zm9udC1mYW1pbHk6JnF1b3Q7VHJlYnVjaGV0IE1TJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzAw NDA4MDsiPk1vYjotIDxzcGFuPjk4MTkwMDIzOTM8L3NwYW4+PC9zcGFuPjwvYj48c3BhbiBzdHls ZT0iZm9udC1zaXplOjEycHQ7Zm9udC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7 LHNlcmlmOyI+PC9zcGFuPjwvcD48YnIgLz48cD7CoDwvcD48YnIgLz48L2Rpdj48YnIgLz48L2Rp dj48YnIgLz48YnIgLz48L2Jsb2NrcXVvdGU+PC9kaXY+