Thread: Re: Issue with pgAdmin4 not finding pg_dump
Which ‘respective person’ ?I am running Ubuntu 22.04 downloaded from the public website: Whether we like it or not Ubuntu ships with most applications now implemented as a snap delivery. I am in effect my own system admin, so I don’t know who you think I should talk to - I can’t change the Ubuntu reliance on snap or change how pgadmin is delivered.on Ubuntu 22.04 the official delivery of PgAdmin and most other is via snap - it maybe not be the intention of the pgadmin developers but there is very little I can do as a single user to change that Ubuntu policy. It seems to me that the pgadmin team need to be the ones who are aware of how one of their supported operating systems delivers their software, and how that delivery potentially impacts the key features of the pgadmin tool. How the development team handle that is far beyond my knowledge- I don’t know if the snap ‘sandbox’ can be relaxed for pgadmin, or if pgadmin can be delivered via an alternative repository (if indeed snap is the issue here).
On Sep 30, 2024, at 5:43 AM, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:Hi Anthony,pgAdmin officially doesn't ship on snap. You need to contact the respective person.On Sat, Sep 28, 2024 at 2:28 AM anthony.flury <anthony.flury@btinternet.com> wrote:Aditya,
Just a thought,
Could this be an issue with the pgadmin being a snap deliverable - I know that snap does some odd things with sandboxing.
Thank you for your support so far.
--
Anthony Flury
On 26/09/2024 04:28, Aditya Toshniwal wrote:Hi Anthony,Please share your binary config and pgAdmin about screenshots.On Wed, Sep 25, 2024 at 7:58 PM anthony.flury <anthony.flury@btinternet.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.flury@btinternet.com> wrote:The validate claims that the files aren't there.
<YDXFKLSD0YbnY7Cb.png>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.png>On Tue, Sep 24, 2024 at 2:28 PM anthony.flury <anthony.flury@btinternet.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 ?
--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"