Search code examples
postgresqlubuntuphpstormpg-dumpdatagrip

PhpStorm in Ubuntu can't detect pd_dump executable on PostgreSQL Export

My environment:

Ubuntu 20.04.3 LTS on Windows 10 -> https://www.microsoft.com/store/productId/9NBLGGH4MSV6

PhpStorm 2022.1 Build #PS-221.5080.224, built on April 13, 2022

My Problem:

I'm trying to export a PostgreSQL database inside the Database tab of PhpStorm.

To execute the export I right click the database in the list and click on the "Export with 'pg_dump'" option. This opens the Export window with all the options and command preview:

Screenshot of the export window with error message

Inside of the window I get the error message "Path to executable is wrong" even tho the pg_dump file exists at the given path /usr/bin/pg_dump. This stops me from executing the export.

I have tried to manually install pg_dump in another directory and select it in the PhpStorm Export window, but it still won't detect the executable. The executable itself works fine.

Solution

  • The solution to this problem was to do a sudo apt-get install postgresql-client.

    Apparently there is a general problem with the pg_dump executable of the "postgresql-client-common" package: https://askubuntu.com/questions/501091/command-pg-dump-not-found

    After installing the postgresql-client package, everything works fine in PhpStorm as well.