Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kBGgd-0006bT-MD for pgsql-tr-genel@arkaria.postgresql.org; Thu, 27 Aug 2020 12:07:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kBGgc-0006SV-Kt for pgsql-tr-genel@arkaria.postgresql.org; Thu, 27 Aug 2020 12:07:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kBGgc-0006SO-A6 for pgsql-tr-genel@lists.postgresql.org; Thu, 27 Aug 2020 12:07:22 +0000 Received: from forward501j.mail.yandex.net ([2a02:6b8:0:801:2::111]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kBGgV-0004OR-05 for pgsql-tr-genel@postgresql.org; Thu, 27 Aug 2020 12:07:21 +0000 Received: from mxback1j.mail.yandex.net (mxback1j.mail.yandex.net [IPv6:2a02:6b8:0:1619::10a]) by forward501j.mail.yandex.net (Yandex) with ESMTP id 5BC893380489; Thu, 27 Aug 2020 15:07:10 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback1j.mail.yandex.net (mxback/Yandex) with ESMTP id krXsQByF3Q-79EOlMng; Thu, 27 Aug 2020 15:07:09 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1598530029; bh=zWqu1kXHYZ8428am+lEgZU87vW4JEyOs0KJnft45DHw=; h=Message-Id:Cc:Subject:In-Reply-To:Date:References:To:From; b=AXN+lKnWY/BHXQoNbEcZvlZpeZMsi1GeSmG/ldkHsV/u/vr5KMs/2OrvEF2DHpMTd bPO5wR/CgDxzuz/3jC3wOqhGLMYUqBtgD6p9s8HvZOB3txycMStye1hnDvMlABZvYt y9s+ucoofq371MEkxw55HYwvmb9Y3kiTndoRQmBI= Authentication-Results: mxback1j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by sas1-f8fae029bfc6.qloud-c.yandex.net with HTTP; Thu, 27 Aug 2020 15:07:09 +0300 From: Samed YILDIRIM To: =?utf-8?B?bXVzdGFmYSBwZWtnw7Z6?= Cc: "pgsql-tr-genel@postgresql.org" In-Reply-To: References: <374331598524872@mail.yandex.com.tr> Subject: Re: Postgres HA ve automatic failover hk. MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 27 Aug 2020 15:07:09 +0300 Message-Id: <2368461598528514@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5NZXJoYWJhbGFyIE11c3RhZmEgQmV5LDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2Pk9uY2Vs aWtsZSByZWFkLXdyaXRlIGxvYWQgYmFsYW5jZSBjaXpkaWdpbml6IG1pbWFyaWRlIG11bWt1biBk ZWdpbC4gMSBhZGV0IHN0YW5kYnknaW5peiBvbGFjYWssIG8gZGEgd2FybSBvbGFjYWssIHlhbmkg b2t1bWF5YSBrYXBhbGkuIE8gbmVkZW5sZSByZWFkIGxvYWQgYmFsYW5jZSBnaXR0aSA6KSBXcml0 ZSBsb2FkIGJhbGFuY2UgaXNlIHphdGVuIFBvc3RncmVTUUwgdmUgc3RyZWFtaW5nIHJlcGxpa2Fz eW9uIGlsZSBoYWxpIGhhemlyZGEgbXVta3VuIGRlZ2lsLCBvIGRhIGdpdHRpIDopIE5lIG9rdW1h eWkgbmUgZGUgeWF6bWEgeXVrdW51IGRhZ2l0YWJpbGVjZWdpbml6IGJpciB5ZXIgeW9rIDopPC9k aXY+PGRpdj7CoDwvZGl2PjxkaXY+VGVrIHZlcmkgbWVya2V6aSBrdWxsYW5peW9yc3VudXosIGJh c2l0IGJpciBtaW1hcmluaXogdmUgYXogc2F5aWRhIHZlcml0YWJhbmkgc3VudWN1bnV6IHZhciwg cmVwbWdyJ2kgaW5jZWxleWViaWxpcnNpbml6LjwvZGl2PjxkaXY+PGRpdj48YSBocmVmPSJodHRw czovL2dpdGh1Yi5jb20vMm5kUXVhZHJhbnQvcmVwbWdyIj5odHRwczovL2dpdGh1Yi5jb20vMm5k UXVhZHJhbnQvcmVwbWdyPC9hPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlBvb2xpbmcga2lzbWlu ZGEgZGEgcGdib3VuY2VyIGt1bGxhbm1heWEga2FyYXIgdmVybWVkZW4gb25jZSBnZXJjZWt0ZW4g cG9vbGluZydlIGlodGl5YWNpbml6IG9sZHVndW5kYW4gZW1pbiBvbG1hbml6ZGEgZmF5ZGEgdmFy LjwvZGl2PjxkaXY+LSBBeW5pIHphbWFuZGEgcHJvamVuaXppIGhhbmdpIGRpbGRlIGdlbGlzdGly aXlvcnN1bnV6PzwvZGl2PjxkaXY+LSBIYW5naSBkcml2ZXInaSBrdWxsYW5peW9yc3VudXo/PC9k aXY+PGRpdj4tIERyaXZlcidpbiBrZW5kaXNpbmluIHBvb2xpbmcgb3plbGxpZ2kgdmFyIG1pPzwv ZGl2PjxkaXY+LSBEcml2ZXInaW4ga2VuZGlzaW5pbiBoZWRlZmluIHlhemlsYWJpbGlyIG9sdXAg b2xtYWRpZ2luaSBrb250cm9sIGV0bWUga2FiaWxpeWV0aSB2YXIgbWk/PC9kaXY+PGRpdj5naWJp IGVrIHNvcnVsYXIgZGEgZ2VsbWV5ZSBiYXNsaXlvci4gRW4gc2lrIGthcnNpbGFzdGlnaW0gZHVy dW1sYXJkYW4gYmlyIHRhbmVzaSBkZSBmYXJraW5kYSBvbG1hZGFuIDIgZGVmYSBwb29saW5nIHlh cG1hayA6KTwvZGl2PjxkaXY+wqA8L2Rpdj48L2Rpdj48YmxvY2txdW90ZT48ZGl2PkHDp8Sxa2Nh c8SxIHllbmkgYmHFn2xheWFuIGJpciBwcm9qZWRlIGVsaW1pemRla2kgdmVyaWxlciBpbGUgZW4g c3RhYmlsL3lhbMSxbiBrdXJndXl1IHBsYW5sYW1hayBpc3RpeW9ydXouIEHDp8SxayBrYXluYWsg dGFyYWbEsW5kYSB0ZWtub2xvamkgw6dlxZ9pdGxpbGnEn2kgZmF6bGEgdmUgcGl5YXNhZGEgaGFu Z2kgdGVrbm9sb2ppIG5lIMWfZWtpbGRlIGt1bGxhbsSxbGTEscSfxLFuxLFuIMO2cm5la2xlcmlu aSB2ZSBkZW5leWltbGVyaSBnw7ZybWVrIGlzdGl5b3J1ei48L2Rpdj48L2Jsb2NrcXVvdGU+PGRp dj5UaWNhcmkgYmlyIGhlZGVmaW5peiB2YXIgaXNlLCBidSBjb3p1bXUgZmlybWFuaXova2VuZGlu aXoga3VsbGFubWFrIGljaW4gZGVnaWwgc2F0bWFrIGljaW4gYXJpeW9yIGlzZW5pejsgYnVudW4g ZW4gZG9ncnUgeW9udGVtaSwgaXNpIGJ1IG9sYW4gYmlyIGZpcm1hL2tpc2kgaWxlIGJpcmxpa3Rl IGNhbGlzbWFrIHZlIHV6bWFuaW5kYW4gZGFuaXNtYW5saWsgYWxtYWsgb2xhY2FrdGlyLiBBcmFk aWdpbml6IHlvZ3VubHVrdGFraSBiaWxnaSBiaXJpa2ltaW5lIGVuIHNhZ2xpa2xpIGJ1IHNla2ls ZGUgdWxhc2FiaWxlY2VnaW5pemUgaW5hbml5b3J1bSA6KTwvZGl2PjxkaXY+QmVzdCByZWdhcmRz LjwvZGl2PjxkaXY+U2FtZWQgWUlMRElSSU08L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2 PjxkaXY+wqA8L2Rpdj48ZGl2PjI3LjA4LjIwMjAsIDE0OjI4LCAibXVzdGFmYSBwZWtnw7Z6IiAm bHQ7cGVrZ296Lm11c3RhZmFAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48ZGl2Pk1l cmhhYmFsYXIsPGRpdj7Dtm5jZWxpa2xlIGfDvHplbCBzb3J1bGFyxLFuxLF6IGnDp2luIHRlxZ9l a2vDvHJsZXIgOik8L2Rpdj48ZGl2Pk9uY2VsaWtsZSBoZW0gSEEgUHJveHkgaGVtIGRlIFBnQm91 bmNlcidpIG5lZGVuIGJpcmxpa3RlIGt1bGxhbm1heWkgdGVyY2loIGV0dGluaXo/IEJ1IGFyYWNs YXJpIGR1c3VudXJrZW4va3VyZ3VsYXJrZW4gaGFuZ2lzaW5pbiBoYW5naSBwcm9ibGVtaSBjb3pt ZXNpbmkgcGxhbmxpeW9yZHVudXo/wqA8L2Rpdj48ZGl2Pi0tSEFQcm94eSByZWFkLXdyaXRlIGxv YWQgYmFsYW5jZSBpw6dpbixwZ2JvdW5jZXIgaXNlIGvEsXNhIHPDvHJlbGkgw6dvayBmYXpsYSBj b25uZWN0aW9uIG9sZHXEn3UgacOnaW4uPC9kaXY+PGRpdj48ZGl2Pi0mZ3Q7IEt1cmd1bGFtYWsg aXN0ZWRpZ2luaXogZmFpbG92ZXIgeWFwaW5pemRha2kgbWltYXJpbml6IG5hc2lsPyBZYW5pLCBr YWMgYWRldCBzdGFuZGJ5IHN1bnVjdW51eiB2YXI/PC9kaXY+PGRpdj4xIG1hc3RlcizFn2ltZGls aWsgMSB0YW5lIHdhcm0sYmVsa2kgYXJ0dMSxcsSxbGFiaWxpci48L2Rpdj48ZGl2Pi0mZ3Q7IEJ1 bmxhcmRhbiBoYW5naWxlcmkgaG90L3dhcm0vY29sZD88L2Rpdj48ZGl2Pi0tMSB0YW5lc2kgd2Fy bTwvZGl2PjxkaXY+LSZndDsgQmlyZGVuIGZhemxhIHZlcmkgbWVya2V6aSBrdWxsYW5peW9yIG11 c3VudXo/IEV2ZXQgaXNlLCBrYWMgdmVyaSBtZXJrZXppIGt1bGxhbmFjYWtzaW5peiB2ZSBidW5s YXJpbiBhcmFzaW5kYWtpIGJhZ2xhbnRpIGhpemkgdmUgZ2VjaWttZSBuZWRpcj88L2Rpdj48ZGl2 Pi0tdGVrIHZlcmkgbWVya2V6aTwvZGl2PjxkaXY+LSZndDsgT3RvbWF0aWsgZmFpbG92ZXIgc2Fk ZWNlIGF5bmkgdmVyaSBtZXJrZXppIGljaW5kZSBtaSBvbGFjYWsgeW9rc2EgdmVyaSBtZXJrZXps ZXJpIGFyYXNpbmRhIGRhIG90b21hdGlrIGZhaWxvdmVyIGlodGl5YWNpIHZhciBtaT88L2Rpdj48 ZGl2Pi0tYXluxLEgdmVyaSBtZXJrZXppbmRlPC9kaXY+PGRpdj4tJmd0OyBIYW5naSBhcmFjbGFy aSBpbmNlbGVkaW5peiwgYnVubGFyZGFuIG5lZGVuIFBhdHJvbmkgc2l6ZSBkYWhhIHlha2luIGdl bGRpPzwvZGl2PjxkaXY+LS1hw6fEsWtjYXPEscKga3VsbGFuYW4gYmlyIGthw6fCoGNhbmzEsSBv cnRhbWRhbiB2ZSBkw7Zrw7xtYW4gYXJhxZ90xLFybWFsYXIgc29udWN1IGRpeWViaWxpcml6Ljwv ZGl2PjxkaXY+LSZndDsgRmVuY2luZydpIG5lIHNla2lsZGUgeWFwYWNha3Npbml6PzwvZGl2Pjwv ZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkHDp8Sxa2Nhc8SxIHllbmkgYmHFn2xheWFuIGJpciBwcm9q ZWRlIGVsaW1pemRla2kgdmVyaWxlciBpbGUgZW4gc3RhYmlsL3lhbMSxbiBrdXJndXl1IHBsYW5s YW1hayBpc3RpeW9ydXouIEHDp8SxayBrYXluYWsgdGFyYWbEsW5kYSB0ZWtub2xvamkgw6dlxZ9p dGxpbGnEn2kgZmF6bGEgdmUgcGl5YXNhZGEgaGFuZ2kgdGVrbm9sb2ppIG5lIMWfZWtpbGRlIGt1 bGxhbsSxbGTEscSfxLFuxLFuIMO2cm5la2xlcmluaSB2ZSBkZW5leWltbGVyaSBnw7ZybWVrIGlz dGl5b3J1ei7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsOHb2sgdGXFn2Vra8O8cmxlci48L2Rp dj48L2Rpdj7CoDxkaXY+PGRpdj5PbiBUaHUsIEF1ZyAyNywgMjAyMCBhdCAxOjUwIFBNIFNhbWVk IFlJTERJUklNICZsdDs8YSBocmVmPSJtYWlsdG86c2FtZWRAcmVkZG9jLm5ldCI+c2FtZWRAcmVk ZG9jLm5ldDwvYT4mZ3Q7IHdyb3RlOjwvZGl2PjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXItbGVm dC1jb2xvcjpyZ2IoIDIwNCAsIDIwNCAsIDIwNCApO2JvcmRlci1sZWZ0LXN0eWxlOnNvbGlkO2Jv cmRlci1sZWZ0LXdpZHRoOjFweDttYXJnaW46MHB4IDBweCAwcHggMC44ZXg7cGFkZGluZy1sZWZ0 OjFleCI+PGRpdj5NZXJoYWJhbGFyLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2Pk9uY2VsaWtsZSBo ZW0gSEEgUHJveHkgaGVtIGRlIFBnQm91bmNlcidpIG5lZGVuIGJpcmxpa3RlIGt1bGxhbm1heWkg dGVyY2loIGV0dGluaXo/IEJ1IGFyYWNsYXJpIGR1c3VudXJrZW4va3VyZ3VsYXJrZW4gaGFuZ2lz aW5pbiBoYW5naSBwcm9ibGVtaSBjb3ptZXNpbmkgcGxhbmxpeW9yZHVudXo/PC9kaXY+PGRpdj7C oDwvZGl2PjxkaXY+LSZndDsgS3VyZ3VsYW1hayBpc3RlZGlnaW5peiBmYWlsb3ZlciB5YXBpbml6 ZGFraSBtaW1hcmluaXogbmFzaWw/IFlhbmksIGthYyBhZGV0IHN0YW5kYnkgc3VudWN1bnV6IHZh cj88L2Rpdj48ZGl2Pi0mZ3Q7IEJ1bmxhcmRhbiBoYW5naWxlcmkgaG90L3dhcm0vY29sZD88L2Rp dj48ZGl2Pi0mZ3Q7IEJpcmRlbiBmYXpsYSB2ZXJpIG1lcmtlemkga3VsbGFuaXlvciBtdXN1bnV6 PyBFdmV0IGlzZSwga2FjIHZlcmkgbWVya2V6aSBrdWxsYW5hY2Frc2luaXogdmUgYnVubGFyaW4g YXJhc2luZGFraSBiYWdsYW50aSBoaXppIHZlIGdlY2lrbWUgbmVkaXI/PC9kaXY+PGRpdj4tJmd0 OyBPdG9tYXRpayBmYWlsb3ZlciBzYWRlY2UgYXluaSB2ZXJpIG1lcmtlemkgaWNpbmRlIG1pIG9s YWNhayB5b2tzYSB2ZXJpIG1lcmtlemxlcmkgYXJhc2luZGEgZGEgb3RvbWF0aWsgZmFpbG92ZXIg aWh0aXlhY2kgdmFyIG1pPzwvZGl2PjxkaXY+LSZndDsgSGFuZ2kgYXJhY2xhcmkgaW5jZWxlZGlu aXosIGJ1bmxhcmRhbiBuZWRlbiBQYXRyb25pIHNpemUgZGFoYSB5YWtpbiBnZWxkaT88L2Rpdj48 ZGl2Pi0mZ3Q7IEZlbmNpbmcnaSBuZSBzZWtpbGRlIHlhcGFjYWtzaW5pej88L2Rpdj48ZGl2Pi4u Li48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Tb3J1bGFyIGJveWxlIHV6YWFyIGdpZGVyIDopIFNp eiBoaWtheWVuaXppIHZlIGhheWFsaW5pemkgYW5sYXRpbiBraSBidW5hIGRhaXIgZG9ncnUgZGVu ZXlpbWxlcmkgYWt0YXJtYWsgbXVta3VuIG9sc3VuLiBIZXIga29zdWxhIHV5YW4gdGVrIGJpciBt b2RlbC9jb3p1bSB5b2sgbWFhbGVzZWYgOik8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2 PjxkaXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rpdj48ZGl2PlNhbWVkIFlJTERJUklN PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4yNy4wOC4y MDIwLCAxMzowOCwgIm11c3RhZmEgcGVrZ8O2eiIgJmx0OzxhIGhyZWY9Im1haWx0bzpwZWtnb3ou bXVzdGFmYUBnbWFpbC5jb20iPnBla2dvei5tdXN0YWZhQGdtYWlsLmNvbTwvYT4mZ3Q7OjwvZGl2 PjxibG9ja3F1b3RlPjxkaXY+TWVyaGFiYWxhciw8ZGl2PsKgPC9kaXY+PGRpdj5Qb3N0Z3Jlc3Fs IG90b21hdGlrIGZhaWxvdmVyIHZlIGNvbm5lY3Rpb24gcG9vbGluZyB5YXDEsXPEsW7EsW4gbmFz xLFsIGt1bGxhbsSxbGTEscSfxLFuYS95YXDEsWxhbmTEsXLEsWxkxLHEn8SxbmEgZGFpciBnw7Zy w7zFnyB2ZSDDtm5lcmlsZXJpbml6ZSBpaHRpeWFjxLFtIHZhci48L2Rpdj48ZGl2Pkt1bGxhbm1h ecSxIHBsYW5sYWTEscSfxLFtxLF6IHlhcMSxZGE6PC9kaXY+PGRpdj5BcHAgU2VydmVyICZndDsm Z3Q7IEhBIFByb3h5wqAmZ3Q7Jmd0OyBQZ0JvdW5jZXIgJmd0OyZndDtQb3N0Z3JlcyBNYXN0ZXIg xZ9la2xpbmRlLjwvZGl2PjxkaXY+wqBQYXRyb25pLWV0Y2Qga3VsbGFuxLFsYXJhayB5YXDEsWxh bmTEsXLEsWxhY2FrLiBBbmNhayBIQSBwcm94eSB2ZSBQZ0JvdW5jZXIgc3VudWN1bGFyxLFuZGEg c2luZ2xlIHBvaW50IG9mIGZhaWx1cmUgZHVydW11IHZlIG9sYXPEsSBzd2l0Y2hvdmVyLGZhaWxv dmVyIGR1cnVtdW5kYSBtYXN0ZXInYSBiYcSfbGFubWFzxLEgacOnaW4gUGdCb3VuY2VyIHZlIEhB UHJveHkgbmFzxLFsIHVwZGF0ZSBlZGlsZWNlxJ9pIGdpYmkga29udWxhcsKgIHZhci4gY29uc3Vs IHZleWEgY29uZmQgaWxlIGlsZXJsZW5lYmlsaXIgZHVydXlvciBhbmNhayBiYcWfa2EgZ8O2csO8 xZ8sw7ZuZXJpIHZleWEgdGVjcsO8YmVsZXJpbml6IHZhcnNhIHBheWxhxZ9hYmlsaXJzZW5peiDD p29rIHNldmluaXJpbS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5NdXN0YWZhIFBla2fDtno8L2Rp dj48ZGl2PsKgPC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPjwvYmxvY2txdW90ZT48L2Rpdj48L2Js b2NrcXVvdGU+