Slony error please help

From: avi Singh <avisingh19811981(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Slony error please help
Date: 2016-06-16 19:36:38
Message-ID: CAETvN5hgp0tDbZcOhwbwL=tvCpDRGTYmcrW_c5gM6m0c3JUHVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-06-16 19:48:12 Re: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Previous Message David G. Johnston 2016-06-16 19:16:08 Re: Comparing tsvector results