RE: Failed to execute pg_dump

From: "Dave Bolt" <dave(at)davebolt(dot)co(dot)uk>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: Failed to execute pg_dump
Date: 2018-01-03 20:29:07
Message-ID: 009101d384d1$8128c380$837a4a80$@co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)journyx(dot)com]
Sent: 03 January 2018 19:15
To: Dave Bolt; pgsql-admin(at)lists(dot)postgresql(dot)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(at)davebolt(dot)co(dot)uk>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2018-01-03 20:36:23 Re: Failed to execute pg_dump
Previous Message Rui DeSousa 2018-01-03 19:23:37 Re: pt_toast table seems to be