ERROR Unable to access file "$ libdir / repmgr_funcs" No such file or directory
I am following this link to create master slave replication on Ubuntu postgresql server.
My config repmgr
and postgresql
:
Postgresql 9.5-: /opt/PostgreSQL/9.5/
repmgr-: /usr/lib/postgresql/9.5/bin/repmgr
repmgr.conf -: /etc/rep.conf
pg_config --pkglibdir => /usr/lib/postgresql/9.5/lib
ls /usr/lib/postgresql/9.5/lib | grep repmgr_funcs => repmgr_funcs.so
I get ERROR-: Can't create function
repmgr_update_last_updated: ERROR: could not access file "$libdir/repmgr_funcs": No such file or directory
ERROR: Unable to create repmgr schema - see preceding error message(s); aborting
source to share
Hi if you are using repmgr
ver. 4 and up, you need to change postgresql.conf
from shared_preload_libraries = 'repmgr_funcs'
toshared_preload_libraries = 'repmgr'
Below are their updates
The repmgr shared library has been renamed from repmgr_funcs to repmgr, meaning shared_preload_libraries in postgresql.conf needs to be updated to the new name:
shared_preload_libraries = 'repmgr'
source to share