pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

pglogical error: pg_restore not found

Open adimania opened this issue 2 years ago • 0 comments

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?

adimania avatar Apr 07 '22 20:04 adimania