Обсуждение: Slony error please help

I am working on a project to upgrade postgresql from 9.4 to 9.5 we use slony for replication 

Phase 1 problem 

1. We had slony version slony1-94-2.2.2-1.rhel5.x86_64 installed when i tried testing upgrade on my test env it failed coz slony 2.2.2 version is not compatible with 9.5 so i upgraded  slony1-94-2.2.2-1.rhel5.x86_64 to slony1-94-2.2.4-4.rhel5.x86_64 which went well. 

Phase 2 problem

1. Back to upgrade testing now when i run the check_upgrade script which includes the command below

/usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -B /usr/pgsql-9.5/bin/ -d /var/lib/pgsql/cmates1/data/ -D /var/lib/pgsql/cmates1/data/9.5/ -p 5432 -P 5433 -c

it throws this error 

Could not load library "$libdir/slony1_funcs.2.2.2"

ERROR:  could not access file "$libdir/slony1_funcs.2.2.2": No such file or directory

/usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -B /usr/pgsql-9.5/bin/ -d /var/lib/pgsql/cmates1/data/ -D /var/lib/pgsql/cmates1/data/9.5/ -p 5432 -P 5433 -c

it throws this error 

Could not load library "$libdir/slony1_funcs.2.2.2"

ERROR:  could not access file "$libdir/slony1_funcs.2.2.2": No such file or directory

Not sure why it is still looking for slony1_funcs.2.2.2 even though the version is upgraded to 2.2.4 and it is running fine. i do see slony1_funcs.2.2.4.so files in lib directory which is how it should be since i have upgraded it to 2.2.4

Any suggestions?

Thanks

Avi

The only thing I can imagine would be that there is another slony cluster (or

remnants of it) hanging around in the 9.4 installation, possibly in another database.

(venv)[postgres@db1 pgbench-tutorial]$ pg_upgrade -b /var/lib/pgsql/test_94/bin -B /var/lib/pgsql/test_95/bin -d /opt/pgsql/test_94 -D /opt/pgsql/test_95 -p 54394 -P 54395 -c

Performing Consistency Checks

-----------------------------

Checking cluster versions                                   ok

Checking database user is the install user                  ok

Checking database connection settings                       ok

Checking for prepared transactions                          ok

Checking for reg* system OID user data types                ok

Checking for contrib/isn with bigint-passing mismatch       ok

Checking for presence of required libraries                 fatal

Your installation references loadable libraries that are missing from the

new installation.  You can add these libraries to the new installation,

or remove the functions using them from the old installation.  A list of

problem libraries is in the file:

    loadable_libraries.txt

Failure, exiting

(venv)[postgres@db1 pgbench-tutorial]$ cat loadable_libraries.txt 

Could not load library "$libdir/slony1_funcs.2.2.2"

ERROR:  could not access file "$libdir/slony1_funcs.2.2.2": No such file or directory