Re: Master slave replication - Mailing list pgsql-admin
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.
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 repmgrI 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); abortingI 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
pgsql-admin by date: