Re: Slony error please help

On Thu, Jun 16, 2016 at 3:36 PM, avi Singh <avisingh19811981(at)gmail(dot)com>
wrote:

> /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
>
>
Using git clones of everything on CentOS 7.1 I cannot reproduce this
problem.
Even the actual pg_upgrade without -c works, the cluster starts up and
replicates
just fine. I went through installing a 9.4 with 2.2.2, then upgrading to
2.2.4 (via
UPDATE FUNCTIONS) and last upgrading to 9.5 with pg_upgrade.

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.

Can you provide a list of all databases and all schemas in them from the
9.4 install?

Regards, Jan

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

--
Jan Wieck
Senior Postgres Architect