Re: Issue with pgAdmin4 not finding pg_dump

You may want to check the permissions on your dump file. It is possible
that pgAdmin does not have rights to that file.

Regards,
Gus

On Wed, Sep 25, 2024 at 11:29 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> 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"
>