Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cz2LC-0004eB-Rl for pgsql-admin@arkaria.postgresql.org; Fri, 14 Apr 2017 14:36:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cz2LC-0001cf-EX for pgsql-admin@arkaria.postgresql.org; Fri, 14 Apr 2017 14:36:50 +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 1cz2JM-0003t2-Kz for pgsql-admin@postgresql.org; Fri, 14 Apr 2017 14:34:56 +0000 Received: from forward4m.cmail.yandex.net ([5.255.216.22]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cz2JJ-0000TU-8C for pgsql-admin@postgresql.org; Fri, 14 Apr 2017 14:34:56 +0000 Received: from mxback8h.mail.yandex.net (mxback8h.mail.yandex.net [IPv6:2a02:6b8:0:f05::111]) by forward4m.cmail.yandex.net (Yandex) with ESMTP id 3E249215D3; Fri, 14 Apr 2017 17:34:51 +0300 (MSK) Received: from web51g.yandex.ru (web51g.yandex.ru [95.108.252.221]) by mxback8h.mail.yandex.net (nwsmtp/Yandex) with ESMTP id FcvYAc34pU-YoZuv7PU; Fri, 14 Apr 2017 17:34:50 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1492180490; bh=HmDsxdJmP+8H9ZBTbTGtTGayxTt4Tp3MQDtoL0j9BvQ=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=YOaxCf1P5iIoT6FPOULBisyjV/nooDGpx4tqwojBqHhtaoUXgWEBezMBSq7EEMm8O HQFMce3Bp7jiszRSvq+5/Q0OKD0K7tL8ThkwPectuazy5lg4ang7BFWrXjvBfvmOWq j7s8PmWClNAZC3xGSEHSVO6Y24jceyW7+nor2QGg= Authentication-Results: mxback8h.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web51g.yandex.ru with HTTP; Fri, 14 Apr 2017 17:34:50 +0300 From: Samed YILDIRIM To: "Gone, Sajan" , "pgsql-admin@postgresql.org" In-Reply-To: References: <416081492115246@web3m.yandex.ru> Subject: Re: Postgres replication MIME-Version: 1.0 Message-Id: <3891051492180490@web51g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 14 Apr 2017 17:34:50 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: 1.1 (+) 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 PGRpdj5IaSBTYWphbiw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Zb3UgY2FuIHVzZSBmb2xsb3dp bmcgcXVlcnkuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+c2VsZWN0ICogZnJvbSBwZ19zdGF0X3Jl cGxpY2F0aW9uOzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rpdj48ZGl2 PlNhbWVkIFlJTERJUklNPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj4xNC4wNC4yMDE3LCAxNzoyMCwgIkdvbmUsIFNhamFuIiAmbHQ7c2dvbmVAbGIuY29t Jmd0Ozo8L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj48ZGl2IHN0eWxlPSJjb2xvcjpyZ2Io MCwwLDApO2ZvbnQtZmFtaWx5OkNhbGlicmksc2Fucy1zZXJpZjsiPjxkaXY+PHNwYW4gc3R5bGU9 ImZvbnQtc2l6ZToxNnB4OyI+SGkgU2FtZWQsPC9zcGFuPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2 PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZweDsiPsKgIFRoYW5rcyBmb3Igc2VuZGluZyBvdXQg dGhlIHdlYmxpbmsuIEkgd2FzIGFibGUgdG8gc3VjY2Vzc2Z1bGx5IHNldCB0aGUgcmVwbGljYXRp b24gdXAgKE1hc3Rlci9TbGF2ZSwgSG90IHN0YW5kIGJ5KS48L3NwYW4+PC9kaXY+PGRpdj7CoDwv ZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNnB4OyI+SSByZWFsbHkgYXBwcmVjaWF0 ZSB5b3VyIGhlbHAgb24gdGhpcy48L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1z aXplOjE2cHg7Ij7CoDwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZw eDsiPk15IGJhY2tncm91bmQgaXMgbW9zdGx5IG9uIE15U1FMIHNvIG15IG5leHQgcXVlc3Rpb24g d291bGQgYmUgb24gaG93IHRvIGxvb2sgYXQgdGhlIHJlcGxpY2F0aW9uIHN0YXR1cy4gTGlrZSBN eVNRTCDCoOKAnFNob3cgc2xhdmUgc3RhdHVzIFxH4oCdIGNvbW1hbmQgaXMgdGhlcmUgYW55IGNv bW1hbmQgb24gcG9zdGdyZXMgdG8gbG9vayBhdCB0aGUgc2xhdmUgY3VycmVudCBzdGF0dXMob3Ig cmVwbGljYXRpb24gc3RhdHVzKS48L3NwYW4+PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGRpdj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjE2cHg7Ij5UaGFuayBZb3UsPC9zcGFuPjwvZGl2PjxkaXY+ PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNnB4OyI+U2FqYW4gR29uZS48L3NwYW4+PC9kaXY+PC9k aXY+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6Q2FsaWJyaTtmb250LXNpemU6MTFwdDt0ZXh0LWFs aWduOmxlZnQ7Y29sb3I6YmxhY2s7Qk9SREVSLUJPVFRPTTptZWRpdW0gbm9uZTtCT1JERVItTEVG VDptZWRpdW0gbm9uZTtQQURESU5HLUJPVFRPTTowaW47UEFERElORy1MRUZUOjBpbjtQQURESU5H LVJJR0hUOjBpbjtCT1JERVItVE9QOiNiNWM0ZGYgMXB0IHNvbGlkO0JPUkRFUi1SSUdIVDptZWRp dW0gbm9uZTtQQURESU5HLVRPUDozcHQ7Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48 c3Ryb25nIHN0eWxlPSJmb250LXdlaWdodDpib2xkOyI+RnJvbTogPC9zdHJvbmc+U2FtZWQgWUlM RElSSU0gJmx0OzxhIGhyZWY9Im1haWx0bzpzYW1lZEByZWRkb2MubmV0Ij5zYW1lZEByZWRkb2Mu bmV0PC9hPiZndDs8YnIgLz48c3Ryb25nIHN0eWxlPSJmb250LXdlaWdodDpib2xkOyI+RGF0ZTog PC9zdHJvbmc+VGh1cnNkYXksIEFwcmlsIDEzLCAyMDE3IGF0IDQ6MjcgUE08YnIgLz48c3Ryb25n IHN0eWxlPSJmb250LXdlaWdodDpib2xkOyI+VG86IDwvc3Ryb25nPlNhamFuIEdvbmUgJmx0Ozxh IGhyZWY9Im1haWx0bzpzZ29uZUBsYi5jb20iPnNnb25lQGxiLmNvbTwvYT4mZ3Q7LCAiPGEgaHJl Zj0ibWFpbHRvOnBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnIj5wZ3NxbC1hZG1pbkBwb3N0Z3Jl c3FsLm9yZzwvYT4iICZsdDs8YSBocmVmPSJtYWlsdG86cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5v cmciPnBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnPC9hPiZndDs8YnIgLz48c3Ryb25nIHN0eWxl PSJmb250LXdlaWdodDpib2xkOyI+U3ViamVjdDogPC9zdHJvbmc+UmU6IFtBRE1JTl0gUG9zdGdy ZXMgcmVwbGljYXRpb248L3NwYW4+PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGRpdj48c3BhbiBz dHlsZT0iZm9udC1zaXplOjE0cHg7Ij5IaSBTYWphbiwgPC9zcGFuPjxkaXY+wqA8L2Rpdj48c3Bh biBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij4gPC9zcGFuPjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQt c2l6ZToxNHB4OyI+WW91IGNhbiB0YWtlIGEgbG9vayBmb2xsb3dpbmcgZG9jdW1lbnQuwqA8c3Bh biBzdHlsZT0iZm9udC1mYW1pbHk6c2Fucy1zZXJpZjsiPkl0IGlzIGdvb2QgZm9yIGEgc3RhcnQg cG9pbnQuPC9zcGFuPjwvc3Bhbj48L2Rpdj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij4g PC9zcGFuPjxkaXY+wqA8L2Rpdj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij4gPC9zcGFu PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+PGEgaHJlZj0iaHR0cHM6Ly93d3cu ZGlnaXRhbG9jZWFuLmNvbS9jb21tdW5pdHkvdHV0b3JpYWxzL2hvdy10by1zZXQtdXAtbWFzdGVy LXNsYXZlLXJlcGxpY2F0aW9uLW9uLXBvc3RncmVzcWwtb24tYW4tdWJ1bnR1LTEyLTA0LXZwcyI+ aHR0cHM6Ly93d3cuZGlnaXRhbG9jZWFuLmNvbS9jb21tdW5pdHkvdHV0b3JpYWxzL2hvdy10by1z ZXQtdXAtbWFzdGVyLXNsYXZlLXJlcGxpY2F0aW9uLW9uLXBvc3RncmVzcWwtb24tYW4tdWJ1bnR1 LTEyLTA0LXZwczwvYT48L3NwYW4+PC9kaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+ IDwvc3Bhbj48ZGl2PsKgPC9kaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+IDwvc3Bh bj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTRweDsiPkJlc3QgcmVnYXJkcy48L3NwYW4+ PC9kaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+IDwvc3Bhbj48ZGl2PjxiciAvPjxz cGFuIHN0eWxlPSJmb250LXNpemU6MTRweDsiPjIyOjI1LCAxMyBOaXNhbiAyMDE3LCAiR29uZSwg U2FqYW4iICZsdDs8YSBocmVmPSJtYWlsdG86c2dvbmVAbGIuY29tIj5zZ29uZUBsYi5jb208L2E+ Jmd0Ozo8L3NwYW4+PGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+wqA8YmxvY2txdW90ZT48ZGl2IHN0 eWxlPSJjb2xvcjpyZ2IoMCwwLDApO2ZvbnQtZmFtaWx5OkNhbGlicmksc2Fucy1zZXJpZjsiPsKg PGRpdj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48c3BhbiBzdHlsZT0iZm9udC1zaXpl OjE2cHg7Ij5IZWxsbyw8L3NwYW4+PC9zcGFuPjwvZGl2PsKgPGRpdj7CoDwvZGl2PsKgPGRpdj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE2cHg7 Ij5Hb29kIGFmdGVybm9vbiBldmVyeW9uZS7CoDwvc3Bhbj48L3NwYW4+PC9kaXY+wqA8ZGl2Pjxi ciAvPsKgPC9kaXY+wqA8ZGl2PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTRweDsiPjxzcGFuIHN0 eWxlPSJmb250LXNpemU6MTZweDsiPsKgIFRoaXMgaXMgU2FqYW4gR29uZSwgSSBhbSB0cnlpbmcg dG8gc2V0dXAgYSBTdGFuZGFyZCBNYXN0ZXIvU2FsdmUgcmVwbGljYXRpb24gYmV0d2VlbiB0d28g cG9zdGdyZXMgaW5zdGFuY2VzLiBJIGFtIHByZXR0eSBtdWNoIG5ldyB0byBwb3N0Z3JlcyBhbmQg bm90IGV4YWN0bHkgc3VyZSBob3cgcmVwbGljYXRpb24gd29ya3MgYW5kIHdoYXQgaXMgYW4gYXJj aGl0ZWN0dXJlIGJlaGluZDxiciAvPml0LiDCoEFzIG9mIG5vdyBJIGFtIGZvbGxvd2luZyB0aGUg c3RhbmRhcmQgcG9zdGdyZXMgZG9jdW1lbnRhdGlvbiBAwqA8YSBocmVmPSJodHRwczovL3VybGRl ZmVuc2UucHJvb2Zwb2ludC5jb20vdjIvdXJsP3U9aHR0cHMtM0FfX3d3dy5wb3N0Z3Jlc3FsLm9y Z19kb2NzX2N1cnJlbnRfc3RhdGljX3dhcm0tMkRzdGFuZGJ5Lmh0bWwtMjNQUkVQQVJJTkctMkRN QVNURVItMkRGT1ItMkRTVEFOREJZJmFtcDtkPUR3TUdhUSZhbXA7Yz1zcFlwMXRaM0FRRDZkZnVJ NnJxYWVnJmFtcDtyPTduMWJMd1hEemVwZ2pLU056aXctbmcmYW1wO209VmkySnhxRU94cjk5Mmli Q0Rlek1BZF9zYmRqYTY1YVJ4TWg0b002V1lwbyZhbXA7cz1RYl9KSnlueEFyMVgtS0VwdjhnLUZW SjRBYzR3dXFMcjZmUjNJZkVWTnBvJmFtcDtlPSI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcv ZG9jcy9jdXJyZW50L3N0YXRpYy93YXJtLXN0YW5kYnkuaHRtbCNQUkVQQVJJTkctTUFTVEVSLUZP Ui1TVEFOREJZPC9hPiw8YnIgLz5ob3dldmVyIGl0IGlzIHNsaWdodGx5IGRpZmZpY3VsdCBmb3Ig bWUgdG8gdW5kZXJzdGFuZC48L3NwYW4+PC9zcGFuPjwvZGl2PsKgPGRpdj48YnIgLz7CoDwvZGl2 PsKgPGRpdj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48c3BhbiBzdHlsZT0iZm9udC1z aXplOjE2cHg7Ij5JdCB3b3VsZCBiZSB2ZXJ5IGhlbHBmdWwgaWYgYW55IG9uZSBjb3VsZCBndWlk ZSBtZSBpbiBhIHByb3BlciB3YXkgb24gc2V0dGluZyB1cCBNYXN0ZXIvU2xhdmUgcmVwbGljYXRp b24gb24gcG9zdGdyZXMuIEFueSByZWNvbW1lbmRhdGlvbnMgb24gZ29vZCBkb2N1bWVudGF0aW9u PGJyIC8+b3Igc3R1ZHkgbWF0ZXJpYWxzIG9uIHBvc3RncmVzIHJlcGxpY2F0aW9uIHdvdWxkIGJl IGhpZ2hseSBhcHByZWNpYXRlZC48L3NwYW4+PC9zcGFuPjwvZGl2PsKgPGRpdj48YnIgLz7CoDwv ZGl2PsKgPGRpdj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48c3BhbiBzdHlsZT0iZm9u dC1zaXplOjE2cHg7Ij5NYW55IFRoYW5rcyBpbiBhZHZhbmNlLjwvc3Bhbj48L3NwYW4+PC9kaXY+ wqA8ZGl2PjxiciAvPsKgPC9kaXY+wqA8ZGl2PsKgPGRpdj48c3BhbiBzdHlsZT0iZm9udC1zaXpl OjE0cHg7Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE2cHg7Ij5UaGFuayBZb3UsPC9zcGFuPjwv c3Bhbj48L2Rpdj7CoDxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZToxNnB4OyI+U2FqYW4gR29uZTwvc3Bhbj48L3NwYW4+PC9kaXY+wqA8ZGl2 PjxiciAvPsKgPC9kaXY+PC9kaXY+PGJyIC8+PGJyIC8+wqA8aHIgLz48YnIgLz48YnIgLz48YnIg Lz48c3BhbiBzdHlsZT0iZm9udC1zaXplOjE0cHg7Ij48Zm9udCBzaXplPSIxIiBmYWNlPSJBcmlh bCIgY29sb3I9IkdyYXkiPk5vdGljZTogVGhpcyBjb21tdW5pY2F0aW9uIG1heSBjb250YWluIHBy aXZpbGVnZWQgYW5kL29yIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbi4gSWYgeW91IGFyZSBub3Qg dGhlIGludGVuZGVkIHJlY2lwaWVudCwgcGxlYXNlIG5vdGlmeSB0aGUgc2VuZGVyIGJ5IGVtYWls LCBhbmQgaW1tZWRpYXRlbHkgZGVsZXRlIHRoZSBtZXNzYWdlIGFuZCBhbnkgYXR0YWNobWVudHMg d2l0aG91dCBjb3B5aW5nIG9yIGRpc2Nsb3NpbmcgdGhlbS4gTEIgbWF5LCBmb3I8YnIgLz5hbnkg cmVhc29uLCBpbnRlcmNlcHQsIGFjY2VzcywgdXNlLCBhbmQgZGlzY2xvc2UgYW55IGluZm9ybWF0 aW9uIHRoYXQgaXMgY29tbXVuaWNhdGVkIGJ5IG9yIHRocm91Z2gsIG9yIHdoaWNoIGlzIHN0b3Jl ZCBvbiwgaXRzIG5ldHdvcmtzLCBhcHBsaWNhdGlvbnMsIHNlcnZpY2VzLCBhbmQgZGV2aWNlcy48 L2ZvbnQ+PC9zcGFuPjxiciAvPjxiciAvPsKgPC9kaXY+PGJyIC8+wqA8L2Jsb2NrcXVvdGU+PHNw YW4gc3R5bGU9ImZvbnQtc2l6ZToxNHB4OyI+IDwvc3Bhbj48L2Rpdj48c3BhbiBzdHlsZT0iZm9u dC1zaXplOjE0cHg7Ij4gPC9zcGFuPjwvZGl2PjwvZGl2PsKgPGhyIC8+PGJyIC8+PGZvbnQgc2l6 ZT0iMSIgZmFjZT0iQXJpYWwiIGNvbG9yPSJHcmF5Ij5Ob3RpY2U6IFRoaXMgY29tbXVuaWNhdGlv biBtYXkgY29udGFpbiBwcml2aWxlZ2VkIGFuZC9vciBjb25maWRlbnRpYWwgaW5mb3JtYXRpb24u IElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHBsZWFzZSBub3RpZnkgdGhl IHNlbmRlciBieSBlbWFpbCwgYW5kIGltbWVkaWF0ZWx5IGRlbGV0ZSB0aGUgbWVzc2FnZSBhbmQg YW55IGF0dGFjaG1lbnRzIHdpdGhvdXQgY29weWluZyBvciBkaXNjbG9zaW5nIHRoZW0uIExCIG1h eSwgZm9yIGFueSByZWFzb24sIGludGVyY2VwdCwgYWNjZXNzLCB1c2UsIGFuZCBkaXNjbG9zZSBh bnkgaW5mb3JtYXRpb24gdGhhdCBpcyBjb21tdW5pY2F0ZWQgYnkgb3IgdGhyb3VnaCwgb3Igd2hp Y2ggaXMgc3RvcmVkIG9uLCBpdHMgbmV0d29ya3MsIGFwcGxpY2F0aW9ucywgc2VydmljZXMsIGFu ZCBkZXZpY2VzLjwvZm9udD48L2Rpdj48L2Jsb2NrcXVvdGU+