I have Dbeaver installed and I have a connection to a PostgreSQL database on a remote server.
I'd like to export this database to my local PC but when I go to Tools -> Backup database I see an error

Client home is not specified for connection

What should I specify and where? I can't find anything about it in the documentation.

7 Answers

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

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/.

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.

Linux Specific Answer

Install PostgreSQL client locally
Open the terminal and type which pg_dump and it will return something like /usr/bin/pg_dump
In local client settings select browse and add the folder from the previous step. In my case it was /usr/bin/. Wait a few seconds it will detect the driver

For Mac,

Right click on your connection -> "Edit Connection". (see image)1

For local client, click browse (see below)2

To see hidden file and folders, press "cmd + shift + ." Now you can browse to PG bin folder. Path will be added to local client. After adding, select that path and you will see id, path, and name will be populated (see image)3

Postgres SQL installed using Enterprise DB installer on Mac OS, pg_restore will be located in /Library/PostgreSQL/10/bin..

So select this location in DBeaver

screenshot for reference

It worked for me..

In Ubuntu 20.04,Add Local Client value as '/user' (in Connection settings -->main)