From: suresh neravati <suresh.neravati@yahoo.com>
To: arvind chikne <arvind.chikne@gmail.com>
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Master slave replication
Date: Sat, 21 Jul 2018 04:01:12 +0000 (UTC)
Message-ID: <993708231.137141.1532145672716@mail.yahoo.com> (raw)
In-Reply-To: <CAB8KJ=g8He3NxhXDtXRvfMg+=CZ8sF=JtCChEw3pT6LcwMGETw@mail.gmail.com>
References: <CAHVLh7RLjy2cHS3rj9FVo5y04M5Cgn_J0+qg5HwUrKgbprG8HA@mail.gmail.com>
<CAGDYbUNNDbNCUnpOzp+C1ADhMoZXRduNJKo44m8E4hs9ek-niQ@mail.gmail.com>
<CA+t6e1mUWfoAMtyzWacFDfZ2Y9DR_a_6vCLmVo2Lk8Q6v+jhFg@mail.gmail.com>
<CAHVLh7QzqftajeNPUsVOQKr_O-UWJp4EPPV4eNtrb4GsQkxT2A@mail.gmail.com>
<CAB8KJ=g8He3NxhXDtXRvfMg+=CZ8sF=JtCChEw3pT6LcwMGETw@mail.gmail.com>
Hi,
There is another open source tool, stolon. sorintlab/stolon This has 3 components, sentinel, keeper and proxy.Sentinel will monitor the Postgresql 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. In case of Failover/switchover, stolon will take care of changing slave 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 Postgresql database on Cloud.
Please let me know if you have any further questions.
Thanks,Suresh Neravati.
|
|
|
| | |
|
|
|
| |
sorintlab/stolon
stolon - PostgreSQL cloud native High Availability and more.
|
|
|
On Friday, July 20, 2018, 5:53:00 PM PDT, Ian Lawrence Barwick <barwick@gmail.com> wrote:
2018-07-20 21:21 GMT+09:00 arvind chikne <arvind.chikne@gmail.com>:
Hi All,
I am trying to configure repmgr
I am getting following error while Initialise the master server
[2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_last_updated: ERROR: 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 preceding error message(s); aborting
I already changed the shared_preload_libraries = 'repmgr' in postgres.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: suresh.neravati@yahoo.com, arvind.chikne@gmail.com, barwick@gmail.com, mariel.cherkassky@gmail.com, shreeyansh2014@gmail.com
Subject: Re: Master slave replication
In-Reply-To: <993708231.137141.1532145672716@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox