It seems like the Apache user ought to be able to run it, then.
Can you enable that account, su to it and try it?
From: Dave Bolt <dave@davebolt.co.uk> Sent: Wednesday, January 3, 2018 2:29 PM To: pgsql-admin@lists.postgresql.org Subject: RE: Failed to execute pg_dump
Hi Scot,
Permissions on the pg_dump file are:
-rwxr-xr-x for owner root, group root.
If I go to the directory and execute as my normal user it seems to be working, at least for
pg_dump --help
From: Scott Whitney [mailto:scott@journyx.com] Sent: 03 January 2018 19:15 To: Dave Bolt; pgsql-admin@lists.postgresql.org Subject: Re: Failed to execute pg_dump
My immediate thought is always permissions.
As whom a phpPgAdmin running? Probably the Apache user who may or may not have rights to see pg_dump.
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5 and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please, fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears to be the configuration file mentioned in the error message and I can’t see any obvious issues.
I searched this problem in the mailing list but could not find any recent results. I did find an older result which said to correct the path in the config file, but that looks right to me.