ERROR could not access file "$libdir/repmgr_funcs" No such file or directory

Question

I follow this link to create master slave replication on Ubuntu postgresql server.

My Configuration of repmgr and postgresql are:

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 am getting ERROR-: unable to create the 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

Answer 1

If you are using repmgr ver. 4 and above then you need to change in postgresql.conf
From shared_preload_libraries = 'repmgr_funcs'
To shared_preload_libraries = 'repmgr'

Below are their upgrade notes

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'