From: Dave Bolt <dave@davebolt.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: RE: Failed to execute pg_dump
Date: Wed, 3 Jan 2018 20:29:07 -0000
Message-ID: <009101d384d1$8128c380$837a4a80$@co.uk> (raw)
In-Reply-To: <CY4PR11MB1575526BB540A62AD11C3AD0A71E0@CY4PR11MB1575.namprd11.prod.outlook.com>
References: <007a01d384c6$9d594260$d80bc720$@co.uk>
<CY4PR11MB1575526BB540A62AD11C3AD0A71E0@CY4PR11MB1575.namprd11.prod.outlook.com>
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.
_____
From: Dave Bolt <dave@davebolt.co.uk>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin@lists.postgresql.org
Subject: Failed to execute pg_dump
Hi Everyone
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.
Any ideas?
Thanks
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here
<http://journyx.com/communication-preferences; or visit
http://journyx.com/communication-preferences to unsubscribe.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dave@davebolt.co.uk, pgsql-admin@lists.postgresql.org
Subject: RE: Failed to execute pg_dump
In-Reply-To: <009101d384d1$8128c380$837a4a80$@co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox