Re: Slony error please help

[Jan Wieck <jan@xxxxxxxxxx>]

On Thu, Jun 16, 2016 at 3:36 PM, avi Singh <avisingh19811981@xxxxxxxxx> 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