1. Stoped slon process on both provider and subscriber nodes 2. installed slony1-94-2.2.4-4.rhel5.x86_64 on both nodes 3. ran the script listed below #!/bin/bash /usr/pgsql-9.4/bin/slonik <<_EOF_
cluster name = slon_cluster_cmates; node 1 admin conninfo = 'dbname=site host=site-db01.qs01.sea1.cmates.com user=repl password='; node 3 admin conninfo = 'dbname=site host=pg-db03.qs01.sea1.cmates.com user=repl password='; update functions ( id = 1 ); update functions ( id = 3 ); _EOF_ 4. Start all slony processes Upgrade executed successfully and replication is running fine since than On Thu, Jun 16, 2016 at 8:44 PM, Venkata Balaji N <nag1...@gmail.com> wrote: > > On Fri, Jun 17, 2016 at 5:36 AM, avi Singh <avisingh19811...@gmail.com> > wrote: > >> 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 >> > > How did you upgrade Slony ? Uninstall Slony, drop slony related schemas > and re-install, re-configure slony from scratch ? or did you ensure > SLONIK_UPDATE_FUNCTIONS has been executed successfully ? > > Regards, > Venkata B N > > Fujitsu Australia > >
