Re: BUG #16568: pg_upgrade failed from 9.3 to 9.6

PG Bug reporting form <noreply@postgresql.org> writes:
>     I am trying to upgrade PG 9.3.4 (repmgr 3.0.1) to PG 9.6.18 (repmgr 4.4)
> . On using pg_upgrade getting below error. 

> $ cat loadable_libraries.txt
> could not load library "$libdir/repmgr_funcs":
> ERROR:  could not access file "$libdir/repmgr_funcs": No such file or
> directory

> $ pg_config --pkglibdir
> /usr/local/pgsql/lib
> $ ll /usr/local/pgsql/lib/repmgr_funcs.so
> -rwxrwxrwx. 1 root root 10220 Mar 27  2018
> /usr/local/pgsql/lib/repmgr_funcs.so

First, are you sure you are interrogating the new installation's
pg_config rather than the old one's?  (If they are both pointing at
/usr/local/pgsql/lib, you have an issue you need to fix right there.)

If that's not it, the most likely interpretation is that the "No such
file" complaint refers to something that repmgr_funcs.so depends on
rather than repmgr_funcs.so itself.  You could try doing

ldd /usr/local/pgsql/lib/repmgr_funcs.so

to see if that shows any unresolved references.

There might also be useful detail in the new postmaster's log file from
the failed pg_upgrade; if ldd doesn't show any problem then you should
look there.

            regards, tom lane