Re: Slony error please help

On Fri, Jun 17, 2016 at 5:36 AM, avi Singh <avisingh19811981(at)gmail(dot)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