Re: Issue with pgAdmin4 not finding pg_dump

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: "anthony(dot)flury" <anthony(dot)flury(at)btinternet(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Issue with pgAdmin4 not finding pg_dump
Date: 2024-09-26 03:28:30
Message-ID: CAM9w-_motRY=FqqSEVD_4wYno4MCfmB0V+jWycnUgyjYgyEctQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Anthony,

Please share your binary config and pgAdmin about screenshots.

On Wed, Sep 25, 2024 at 7:58 PM anthony.flury <anthony(dot)flury(at)btinternet(dot)com>
wrote:

> all of the executables have world read, write and execute permissions (as
> expected) so I can't see that being the problem.
>
> the pg_dump program links to /usr/share/postgresql-common/pg_wrapper which
> also has world execute permission - so that isn't a problem either.
>
>
> On 25/09/2024 13:23, Aditya Toshniwal wrote:
>
> Hi Anthony,
>
> It looks like pgAdmin is not able to access the files for execute
> permissions. Can you check once?
>
> On Wed, Sep 25, 2024 at 4:42 PM anthony.flury <
> anthony(dot)flury(at)btinternet(dot)com> wrote:
>
>> The validate claims that the files aren't there.
>>
>> Although this is clearly incorrect since the files are there and can be
>> executed without the need sudo or any other privelege execution.
>>
>>
>> On 24/09/2024 10:52, Aditya Toshniwal wrote:
>>
>> Hi Anthony,
>>
>> What is the output of validate in preferences -> binary paths?
>>
>> [image: image.png]
>>
>> On Tue, Sep 24, 2024 at 2:28 PM anthony.flury <
>> anthony(dot)flury(at)btinternet(dot)com> wrote:
>>
>>> I am trying to do a simple backup of my PostGreSql 12 database via
>>> pgAdmin4 (v 8.12) on Ubuntu 22.04
>>>
>>> In Preferences I have the path for PostGre 12 set to '/usr/bin/', and I
>>> have confirmed that that pg_dump utility exists in /usr/bin directory, and
>>> I can run pg_dump from the command line.
>>>
>>> However when I select 'backup' for my database in pgAdmin4, it generates
>>> an error saying `/usr/bin/pg_dump' not found (despite it being there).
>>>
>>> What is the problem here ?
>>> --
>>> Anthony Flury
>>> *Moble*: +44 07743 282707
>>> *Home*: +44 (0)1206 391294
>>> *email*: anthony(dot)flury(at)btinternet(dot)com
>>>
>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>> <https://www.enterprisedb.com/>
>> "Don't Complain about Heat, Plant a TREE"
>>
>> --
>> Anthony Flury
>> *Moble*: +44 07743 282707
>> *Home*: +44 (0)1206 391294
>> *email*: anthony(dot)flury(at)btinternet(dot)com
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>
> --
> Anthony Flury
> *Moble*: +44 07743 282707
> *Home*: +44 (0)1206 391294
> *email*: anthony(dot)flury(at)btinternet(dot)com
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Gus Spier 2024-09-27 01:17:33 Re: Issue with pgAdmin4 not finding pg_dump
Previous Message Aditya Toshniwal 2024-09-26 03:26:33 Re: Unable to run PGAdmin in Ubuntu 24