From: | suresh neravati <suresh(dot)neravati(at)yahoo(dot)com> |
---|---|
To: | arvind chikne <arvind(dot)chikne(at)gmail(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
Cc: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Master slave replication |
Date: | 2018-07-21 04:01:12 |
Message-ID: | 993708231.137141.1532145672716@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
|
|
|
| | |
|
|
|
| |
sorintlab/stolon
stolon - PostgreSQL cloud native High Availability and more.
|
|
|
On Friday, July 20, 2018, 5:53:00 PM PDT, Ian Lawrence Barwick <barwick(at)gmail(dot)com> wrote:
2018-07-20 21:21 GMT+09:00 arvind chikne <arvind(dot)chikne(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | arvind chikne | 2018-07-21 12:01:21 | Re: Master slave replication |
Previous Message | Ian Lawrence Barwick | 2018-07-21 00:52:26 | Re: Master slave replication |