Ubuntu Dbeaver backup database

MAC specific answer

I ran into the same issue. Essentially, DBeaver needs to know where the postgresql bin is located. It contains things like pg_dump which the backup tool depends on. If you don't have PostgreSQL installed, then I'd recommend installing via: postgresapp.com

For version 11, as of this comment, the lib installation will be located here: /Applications/Postgres.app/contents/versions/11/bin.

Versions installed with brew are located in /usr/local/bin/postgres.

So within DBeaver you'll want to edit the DB connection properties to reflect the below screenshot. You'll be prompted to reconnect to your DB, but then you should be good to go.

Hope this helps.

enter image description here


I use Windows 7, so maybe it doesn't work the same way, but it is worth a try. First you have to install your local postgresql server. When this is done, it's quite simple, just make a rightclick on your PostgreSQL connection and then click on "Edit Connection". Here you can choose your local client.

I must say, I've search long enough for this on my own. Hope it helps.

And it is my first post, so sorry if I did something wrong.

Screenshot Server Connection:

Screenshot Server Connection

Screenshot Edit Settings:

Screenshot Edit Settings


I found this solution using ubuntu linux:

look for pg_dump running this command as root

find / -name "pg_dump"

in my case, the relevant result is /usr/lib/postgresql/12/bin/pg_dump

Then, in "Connection Settings" as other answers here, click on "browse" and browse to /usr/lib/postgresql/12/bin/pg_dump or the location resulted on the previous step.