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
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