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