could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so"

Started by armand pirvuover 8 years ago2 messagesgeneral
Jump to latest
#1armand pirvu
armand.pirvu@gmail.com

So I ventured in uninstalling the
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/ <https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/&gt;

yum install http://packages.2ndquadrant.com/pglogical/yum-repo-rpms/pglogical-rhel-1.0-3.noarch.rpm <http://packages.2ndquadrant.com/pglogical/yum-repo-rpms/pglogical-rhel-1.0-3.noarch.rpm&gt;
yum install postgresql95-pglogical

testrep=# create extension pglogical;
ERROR: could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so"

Even if I get back to 1.0.2 same problem which makes me think the issue might be in latest package

postgresql95-pglogical x86_64 1.2.2-1_2ndQuadrant.el7.centos ok
postgresql95-pglogical x86_64 2.0.1-1.el7 broken

What I did notice is the repo different name

The main issue is that now I am dead in the water on this project

Any idea how to fix or at leat get back the 1.2.2-1 version ?

Thanks
Armand

#2armand pirvu
armand.pirvu@gmail.com
In reply to: armand pirvu (#1)
Re: could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so"

Looks like upgrading from 9.5.2 to 9.5.8 did it
I had another box on 9.5.5 and it was broken there too

Show quoted text

On Aug 10, 2017, at 2:13 PM, armand pirvu <armand.pirvu@gmail.com> wrote:

So I ventured in uninstalling the
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/ <https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/&gt;

yum install http://packages.2ndquadrant.com/pglogical/yum-repo-rpms/pglogical-rhel-1.0-3.noarch.rpm <http://packages.2ndquadrant.com/pglogical/yum-repo-rpms/pglogical-rhel-1.0-3.noarch.rpm&gt;
yum install postgresql95-pglogical

testrep=# create extension pglogical;
ERROR: could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so"

Even if I get back to 1.0.2 same problem which makes me think the issue might be in latest package

postgresql95-pglogical x86_64 1.2.2-1_2ndQuadrant.el7.centos ok
postgresql95-pglogical x86_64 2.0.1-1.el7 broken

What I did notice is the repo different name

The main issue is that now I am dead in the water on this project

Any idea how to fix or at leat get back the 1.2.2-1 version ?

Thanks
Armand