Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgj5H-0007yc-2O for pgsql-admin@arkaria.postgresql.org; Sat, 21 Jul 2018 04:01:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgj5E-0000Kq-6h for pgsql-admin@arkaria.postgresql.org; Sat, 21 Jul 2018 04:01:28 +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.89) (envelope-from ) id 1fgj5C-0000KK-BA for pgsql-admin@lists.postgresql.org; Sat, 21 Jul 2018 04:01:27 +0000 Received: from sonic305-2.consmr.mail.bf2.yahoo.com ([74.6.133.41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgj54-0004x0-V8 for pgsql-admin@postgresql.org; Sat, 21 Jul 2018 04:01:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1532145676; bh=9bt614ctZts0Sy3bsYasZZw0UfB6zMMPmTe7EUxsH5s=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=nX1ngyX/cdaTUbk1CYLNJNByNcpgT4eg6IovNzbvbzoEUvOdnllR0+z/BDgogmxU2jMRtOjvuV5ZNwq00u9rdPpS0XkoImoQHAsMrHpHMqvU5vjOLTA996jlh4I2IxbML3pmugvv/JIchzdvT1Fw2osVpOacEeWy5Wq41N/G5Sc9VSSwVLpAFxMR/AvJWz+T8CA+1CigB/eUp6C9TBJWIUHeDUFgx9vGnrQM2t6S2LEWWgcD9hcW7HnxMxH99Dzj/1wgraN+C+CKeuQPyRnYEm1U5FT1gzaCD7WkO8v1kv2nm+3gjMhqdqCruXTP6BcAXznPvbF/88tXIrQaOj/b+Q== X-YMail-OSG: zsglzDgVM1njM.k25idH.02Q0kQ1uzE.gR4aWz3Oeix12rkSPCToe7ojIvSaJV0 b5gTgb3_5pyq7qVnvNgRqDPFGGOPrBNncHYeyYve.5DbzCMUFfZy8RbSdCrrxEePNcglGlmqftAt oqgyO1zYKS.e40YCvr1TX3oJVUFYX2eUZxzKfqhqAIZWyKPfAiOHvw5vlBK9H7Wxy0KIy.9xvYKx W9JpjyAYpVofPEG2f3A6L4FwOTzAt.P4ot.0nI3a4qZWC3CxAU0M_NDt4bi28xHO19L99OkRPjgx uS7lEIjtZqZ3OgQqVatuAesaSL9BRTugDVweV922D68BczB1O1pCjL.jQg8lZAXA4TPE5bqksk4B 6o0rmfEbdInliBP6vz3EyivnfrkBEpj74X4ksui4BlBfd388XKY44c..lH_IbkzJNrp_FXnSv1kO ti7Q86zN15hQVMu1tr4Hx5P.QWUBIW99Lp.RgbKTOnh6W_Z1WYyW5qvOwphE96rq18LcXPe54IFE e5iaDu4ht33ezDyi9Vv3.4wwwYawKL1t6c_eYyPKMs751tDYO3G84F94nhyD3xwM.V9xo_jYE6Ff 4odMfW_T87XMm3TWpilFHQkB_WbAAqewYWZ5BLdELu5mLJHiu_KASliM2JDsYfLzM.1SEwg.ohRv cU41td8kDXSgw1IWc34TlKPvEUbIlE1GBMgD8q5U.TYJr7Zw6xOzr4dGRL1pb5R3J4XBi4_BBI0M ouBdTq0fkBOBBEtZ0Zg7l637xtiZiXdVOvxOFS3P0mHcTGLtyKzsGZbCdFm0TD_tDyD4mOFc2jVu Pif5Ywsz2pLw4Ept_IorEYuXKiBJEHchqrJ6gSwgrPbhJFBngJ25rat0bVqWjiPvSI7aoOYs940f 7groJ9d80NuoUHSDZ4zyV1Om3XR0MKPT81LM5ZMOJ3unUsLxyXXE66fZg5zBrhWZ_uY63SRbuOKd NFr2kUYTO.C7kW8lI5Hyn76vL_LRAHS55_b.H6TY6Qr1uiRJJVXEcRF3cDRJPo.cbn5grXIpWqyj gA7M5xFsYebb9x0RYa_xv.wJKXKmvJ8THj.dYSjKhwXwm.Lb1rwAzvQs- Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.bf2.yahoo.com with HTTP; Sat, 21 Jul 2018 04:01:16 +0000 Date: Sat, 21 Jul 2018 04:01:12 +0000 (UTC) From: suresh neravati To: arvind chikne , Ian Lawrence Barwick Cc: Mariel Cherkassky , Shreeyansh Dba , pgsql-admin Message-ID: <993708231.137141.1532145672716@mail.yahoo.com> In-Reply-To: References: Subject: Re: Master slave replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_137140_1094604772.1532145672714" X-Mailer: WebService/1.1.12144 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0 Content-Length: 11651 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_137140_1094604772.1532145672714 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, There is another open source tool, stolon.=C2=A0sorintlab/stolon This has 3= components, sentinel, keeper and proxy.Sentinel will monitor the Postgresq= l database master/slave, Keeper will manages the Postgresql database on the= node, Proxy maintains the connection coming from application to database. Stolon will monitor and maintain the streaming replication automatically.= =C2=A0 In case of Failover/switchover, stolon will take care of changing sl= ave to master and failed master to standby automatically. Only one additional thing you need is Consul/etcd to store the master/slave= instant information by stolon. This works even for the Kubernates in case if you want to use the Postgresq= l database on Cloud. Please let me know if you have any further questions. Thanks,Suresh Neravati. |=20 |=20 |=20 | | | | | |=20 | |=20 sorintlab/stolon stolon - PostgreSQL cloud native High Availability and more. | | | On Friday, July 20, 2018, 5:53:00 PM PDT, Ian Lawrence Barwick wrote: =20 =20 =20 2018-07-20 21:21 GMT+09:00 arvind chikne : Hi All,=C2=A0 I am trying to configure=C2=A0repmgr=C2=A0 I am getting following error while=C2=A0Initialise the master server=C2=A0 [2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_l= ast_updated: ERROR:=C2=A0 could not access file "$libdir/repmgr_funcs": No = such file or directory [2018-07-20 17:41:23] [ERROR] Unable to create repmgr schema - see precedin= g error message(s); aborting I already changed the=C2=A0shared_preload_libraries =3D 'repmgr' in postgre= s.conf in master server but still getting the same error pls suggest How did you install repmgr, e.g. from an OS package (which?) or from source= ? Regards Ian Barwick =20 ------=_Part_137140_1094604772.1532145672714 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

There is another open source tool= , stolon. so= rintlab/stolon This has 3 components, sentinel, keeper and proxy.
=
Sentinel will monitor the Postgresql database master/slave, Keeper wil= l manages the Postgresql database on the node, Proxy maintains the connecti= on coming from application to database.

Stolon wil= l monitor and maintain the streaming replication automatically.  In ca= se of Failover/switchover, stolon will take care of changing slave to maste= r and failed master to standby automatically.

Only= one additional thing you need is Consul/etcd to store the master/slave ins= tant information by stolon.

This works even for th= e Kubernates in case if you want to use the Postgresql database on Cloud.

Please let me know if you have any further question= s.

Thanks,
Suresh Neravati.