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

PG Bug reporting form <noreply(at)postgresql(dot)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