pg_dump executable is missing
Completed
Hi there
I'm trying to run dump with pg dump, but it says the executable is missing. Any idea?
Am using DataGrip 2017.3.7
Build #DB-173.4674.7, built on February 28, 2018

Please sign in to leave a comment.
pg_dump is normally in your install dir. Something like C:\\PostgreSQL\pg96/binpg_dump.exe. You have to upgrade the field that says "Path to pg_dump". It had the red exclamation mark.
You also need to be sure postgresql has permissions to write to the target directory.
Hi Antonyo
Thanks for your quick response. I can't see the PostgreSOL folder suggested.
I have located the file after performing a search. Thanks for you help.
Hi,
I pointed all directories as requested, but still getting this error. Any ideas?
Thanks.
Changed but still..
@Alibega Since you want to invoke restore action you need specify path to pg_restore.exe. What I see on your screenshot is path to pg_dump.exe.
E.g.:
What if postgre is running inside docker?
Then you need to download PostgreSQL binaries in zip archive, unpack it and find utilities in ...\bin folder.
The same question but my PostgreSQL is in docker
So I installed the docker plugin successfully.
Then ? to fill in the Datagrip form Path to pg_dump
>Then ? to fill in the Datagrip form Path to pg_dump
In case you want to use pg_dump in DataGrip you have to install it locally on your machine.
Issue still exists, embarassing not to fix the most basic functionality imaginable in an entire decade.
R Marcinkevicius, there are a few ongoing tickets related to this issue. Please report your issue on our tracker by specifying your DBMS and local db / docker container path you specify in the dialog. We'll collect the information and add it to our planning
In short: on a fresh pc, install datagrip, install pg on datagrip, run docker container with pgsql, try to make backup, it will give you this error, it appears because datagrip installs postgres drivers without this functionality, to fix install pgsql directly to user pc
https://youtrack.jetbrains.com/issue/DBE-21439/Bundle-PostgreSQL-dump-tools-to-DataGrip-distribution