2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.02k stars 154 forks source link

pglogical error: pg_restore not found #374

Open adimania opened 2 years ago

adimania commented 2 years ago

I am running pg_logical on postgres 14 to bring data from postgres 11.

# rpm -qa|grep pglogical
pglogical_14-2.4.1-1.rhel8.x86_64

I was able to create a publisher, subscriber, and a subscription but I am getting this in my logs on pg 14 (the subscriber):

< 2022-04-07 20:18:31.560 UTC >ERROR:  could not execute pg_restore ("/usr/pgsql-14/bin/pg_restore"): No such file or directory

However the file pg_restore definitely exists:

# ls -l /usr/pgsql-14/bin/pg_restore
-rwxr-xr-x. 1 root root 192080 Feb  9 08:14 /usr/pgsql-14/bin/pg_restore

My selinux is set to permissive, so that is not interfering. Can someone please help me understand what is wrong here?