DBeaver 8.0: impossible to specify PostgreSQL client home

[ced75]

Hi,

I'm testing the new DBeaver release 8.0 on Linux Mint 17.3.
When I try the new "Backup database" tool, I have a message on top of the "Database backup" window displaying: "Client home is not specified for connection".

So, I edit my connection. There, I suppose the client home can be defined with "Local Client" combobox.
I clic on "Browse...", then on "Add home" and I select the repository where my local PostgreSQL binaries are on my computer.
When I validate, nothing appears in the window. The fields ID, Path, Name, etc. can not be filled in.

I have the same problem in the PostgreSQL driver interface.

What am I doing wrong?

Thanks for your help.
Regards,

Cedric

[serge-rider]

PostgreSQL native tools seems to be working only on Windows machines in this version (where native client home is taken from Windows registry).
Will be fixed (and improved) in 3.8.1.
Thanks for report.

[skif-sarmat]

It doesn't work on Windows 10 too. The behavior is similar to the behavior in the first message.

[serge-rider]

It works only if you have installed PG using windows installer (and thus you have some information in registry). Anyhow this will be fixed in the next version.

[phouverneyuff]

This error continues occur in Ubuntu 16.04 on export database using DBEaver 4.0

[serge-rider]

You can configure PG client home in connection setting dialog.
Click on Local client combo->Browse->Add home->/usr/bin (or other location where psql/pg_dump/pg_restore reside).

[Gallaecio]

With DBeaver installed at /home/<username>/software/dbeaver, and executing DBeaver from a terminal to see the output, when I try to add /usr/bin as client home nothing happens on the GUI and the terminal shows:

Home '/usr/bin' is not supported

Is that expected?

[hollerith]

Try running which pg_dump - or try /opt/PostgreSQL/9.6/bin

[Gallaecio]

$ which pg_dump
/usr/bin/pg_dump

[filosssof]

I'm sorry for the stupid question, but where is the ... client combo in 4.0.8 version?

[serge-rider]

[lukaseder]

Stumbling upon this, could that local client setting perhaps be pointed out in the error message to help future users find this setting? I keep forgetting this as I upgrade PostgreSQL to newer versions and delete the older versions...

[ducdigital]

For those who cannot find this dropdown box. I admit the UI is not very welcoming.
A link to open connection setting directly would be the best. Also, maybe a clearer error message?

[kshitijahuja]

Now that I was able to find the Edit Connection, the Add Home does not allows to input text url. Instead, we have to choose a path by browsing. My Mac does not shows the hidden usr directory in that dropdown despite turning on to view the hidden files.

[brian-lamb-software-engineer]

on my mac, i had to brew install postgres, then which pg_dump which was /usr/local/bin/pg_dump. So then add home /usr/local/bin to the connection under Connection settings tab, Local Client. Note when you browse for the path, you need to press cmd + shift + . to expose hidden files to see the usr directory.

[lherreranetlink]

@kshitijahuja were you able to find a solution ? If so, what was it?

[kshitijahuja]

@kshitijahuja were you able to find a solution ? If so, what was it?

Nope.

[minthaka]

You only need to select the home folder for the postgres tools. On Linux I had to select /usr/bin , where the installed pg_dump resides.

[adamchenwei]

@brian-lamb-software-engineer solution worked perfectly! Thanks

[mbasaglia]

I'm getting similar issues, I've set the client home as /usr/bin but end up getting the error

2020-01-30 11:01:44.712 - IO error: Utility 'pg_dump' not found in client home '/usr/bin' (/usr/bin)

The path is correct though

$ which pg_dump
/usr/bin/pg_dump
$ ls -l /usr/bin/pg_dump
lrwxrwxrwx 1 root root 37 Nov 13 16:15 /usr/bin/pg_dump -> ../share/postgresql-common/pg_wrapper

[chris-crawford]

Now that I was able to find the Edit Connection, the Add Home does not allows to input text url. Instead, we have to choose a path by browsing. My Mac does not shows the hidden usr directory in that dropdown despite turning on to view the hidden files.

@kshitijahuja cmd+shift+g within the finder window allows for direct folder input -- I ran through this post and was successfully able to point to my bin directory for postgres install (mine was installed via Brew, so is in usr/local/Cellar/postgresql/10.5/bin )

[alexorbit]

How to set native app on Mac:
Download Postgres.app latest release
https://postgresapp.com/downloads.html
Move to applications folder.

Setup home folder:
Connection settings => Local Client
applications folder => Postgres.app/Resources/Versions/xx/bin

[thanhdx0]

I can't set client home to /usr/bin on ubuntu 19.04 because of permission denied error when I choose /usr folder in file browser.
How can I do? I'm using DBearve-ce 7.0.2 and install DBeaver by snap.

[ingmferrer]

I can't set client home to /usr/bin on ubuntu 19.04 because of permission denied error when I choose /usr folder in file browser.
How can I do? I'm using DBearve-ce 7.0.2 and install DBeaver by snap.

Im having this exact problem in ubuntu 20.04, cannot set /usr/bin/ because denied permissions.

[jelnur]

Now that I was able to find the Edit Connection, the Add Home does not allows to input text url. Instead, we have to choose a path by browsing. My Mac does not shows the hidden usr directory in that dropdown despite turning on to view the hidden files.

If you installed Postgres.app the path is like this:
/Applications/Postgres.app/Contents/Versions/11/bin

[rtriveurbana]

I can't set client home to /usr/bin on ubuntu 19.04 because of permission denied error when I choose /usr folder in file browser.
How can I do? I'm using DBearve-ce 7.0.2 and install DBeaver by snap.

Im having this exact problem in ubuntu 20.04, cannot set /usr/bin/ because denied permissions.

same problem

[JOSERUIZ7]

The same thing happens to me, what can I do?

[bratislavml]

For the Ubuntu permission issue: This issue is related with the Snap version of dbeaver, the one installed through Ubuntu Software. I managed to resolve the issue by uninstalling it, downloading the installer from https://dbeaver.io/download/ and running sudo dpkg -i dbeaver-ce_7.1.0_amd64.deb (the current version)

This version has access to the usr folder.

This doesn't work for me on Ubuntu 18.04, I can access /usr/bin/ but no permissions for pg_dump.

[josemateuss]

Same problem here

[pleshevskiy]

I also cannot set /bin or /usr/bin as client home. I tried to make link to user home via ls -s /usr/bin/pg_dump ~/pg_dump and it also not work

[kseniiaguzeeva]

Please create a new ticket for this issue

[embojker]

I've spent an hour trying to figure out how to open a location /usr/local/bin in the Browse dialog window in Mac... until I found here the key combination (posted by @brian-lamb-software-engineer).

Everyone using Mac would have to press Command + Shift + . (dot) to be able to see ALL the directories in the Browse dialog. Afterwards it is an easy pick. Just open the folder you got as the result of which pg_dump execution.

Cheers!

[Artofaj]

I also cannot set /bin or /usr/bin as client home. I tried to make link to user home via ls -s /usr/bin/pg_dump ~/pg_dump and it also not work

I can confirm this issue.

[tcampbPPU]

For those on running Ubuntu and having an issue with setting the Local Client for Postgres to the '/usr/bin' through the file selector GUI I have had the same issue. I order to fix, you cannot install the DBeaver from Snap store directly instead, install via the CLI, via the following:

Make you have Java and JDK
$ java -version

Add Debian repository and Install DBeaver CE
$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list

After adding the repo, update the apt list and install DBeaver CE
$ sudo apt update
$ sudo apt -y install dbeaver-ce

Hopefully this helps anyone struggling :)

[yckbilly1929]

For those on running Ubuntu and having an issue with setting the Local Client for Postgres to the '/usr/bin' through the file selector GUI I have had the same issue. I order to fix, you cannot install the DBeaver from Snap store directly instead, install via the CLI, via the following:

Make you have Java and JDK
$ java -version

Add Debian repository and Install DBeaver CE
$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list

After adding the repo, update the apt list and install DBeaver CE
$ sudo apt update
$ sudo apt -y install dbeaver-ce

Hopefully this helps anyone struggling :)

can confirm that Permission denied issue exists for snap version in Ubuntu 20.10

current workaround is switching back to apt like the above

[foxbit19]

Unfortunately, public key is outdated.
No way to use snap version with pg_dump.
I've managed using this link: https://dbeaver.io/debs/dbeaver-ce/ to download the .deb package.

[OzzyTheGiant]

It's definitely proven to be hard to use the snap version of DBeaver to restore. Heck, I don't even trust it to restore CSV files as it messed up my boolean data once. Use pgAdmin instead. Be sure that if you do a back up, try doing it as a TAR file, as the plain format doesn't work since pg_restore complains about it being an SQL file, forcing you to use psql, but then psql complains about null values being written as \N, which was basically a dead end for me. PgAdmin works better with TAR files for restores.

[LeandroRezendeCoutinho]

Same problem on OpenSuse Tumbleweed.
Postgres client already installed.

[MatthausNawan]

awesome @brian-lamb-software-engineer , all that works!

[EltonCarreiro]

Unfortunately, public key is outdated.
No way to use snap version with pg_dump.
I've managed using this link: https://dbeaver.io/debs/dbeaver-ce/ to download the .deb package.

Confirming, I had permission issues when trying to specify the pg_dump but unfortunately snap version doesn't work, so I've installed the .deb package directly from the DBeaver site and it worked! 🎉

[slash851]

For those using Ubuntu 20.10
I had the same problem with permissions when using DBeaver insalled from Ubuntu Software (snap version)

Solution that works for me:

1. Uninstall snap version of DBeaver from Ubuntu Software panel.
2. Go to: https://dbeaver.io/download/
3. Download DEB Linux Debian package 64 bit (installer) (https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb)
4. Simply double click to Install downloaded package via Ubuntu Software

With newly installed version I can modify the Home Path:

[foxbit19]

Yes, I've done it exactly in that way and it works!
We have to forgot the snap edition for now.

[abinhho]

This worked for me.
Mac M1 but I think Intel chip should work as well.

$ brew install libpq

Then add /opt/homebrew/opt/libpq/bin to Local Client

[paladini]

For those using Ubuntu 20.10 I had the same problem with permissions when using DBeaver insalled from Ubuntu Software (snap version)

Solution that works for me:

1. Uninstall snap version of DBeaver from Ubuntu Software panel.
2. Go to: https://dbeaver.io/download/
3. Download DEB Linux Debian package 64 bit (installer) (https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb)
4. Simply double click to Install downloaded package via Ubuntu Software

I was facing the same issue in Ubuntu too and this comment solved my problem.

Also, for the step (1) you can uninstall Dbeaver (Snap Version) via Terminal:

sudo snap remove dbeaver-ce

Thanks for the tip, mate!

[krzysztofjeziorny]

My experience on Debian 11 Bullseye, I had DBeaver installed with Flatpak. Trying to add a Native Client home for a Postgresql client located in /usr/bin, it changed this path into /run/user/1000/doc/ff43939c/bin and then didn't find the binaries.

I've downloaded the 'normal' zip package to extract, it works as intended with pg_dump and pg_restore.

[Destrolaric]

@krzysztofjeziorny, Hi we investigated this issue sometime before, unfortunately, it's a flatpack issue. A workaround can be found here #5008

[m4ss1m0g]

Anyone knows if is possible to change the Name field on the form (which is then displayed on the combo), on Win this field is read-only. Maybe editing a settings file...

[JuinEsp]

For the Ubuntu permission issue: This issue is related with the Snap version of dbeaver, the one installed through Ubuntu Software. I managed to resolve the issue by uninstalling it, downloading the installer from https://dbeaver.io/download/ and running sudo dpkg -i dbeaver-ce_7.1.0_amd64.deb (the current version)

This version has access to the usr folder.

Para mim, isso serviu muito bem.

[fawazahmed-yara]

Thanks @serge-rider for this. This worked for me to create a dump.
Had to enable hidden files (cmd + shift + .) to select libpq/bin path

Then to restore db, had to use this cmd:
psql -U username -p 5432 -h 10.10.10.1 -d database < db.dump

[vanduc1102]

on MAC, it will be 100x faster if we can input the path directly, instead of browsing 😢

[cyberdude]

on my mac, i had to brew install postgres, then which pg_dump which was /usr/local/bin/pg_dump. So then add home /usr/local/bin to the connection under Connection settings tab, Local Client. Note when you browse for the path, you need to press cmd + shift + . to expose hidden files to see the usr directory.

It would be nice if you can add a field to input it manually. Finder explorer doesn't have all the hidden files exposed by default

[johnny68]

on my mac, i had to brew install postgres, then which pg_dump which was /usr/local/bin/pg_dump. So then add home /usr/local/bin to the connection under Connection settings tab, Local Client. Note when you browse for the path, you need to press cmd + shift + . to expose hidden files to see the usr directory.

Someone needs to add this to the official documentation for MacOS. this is the third time I forgot the keystrokes and had to find this particular comment.

[girgirius]

For those using Ubuntu 20.10 I had the same problem with permissions when using DBeaver insalled from Ubuntu Software (snap version)

Solution that works for me:

1. Uninstall snap version of DBeaver from Ubuntu Software panel.
2. Go to: https://dbeaver.io/download/
3. Download DEB Linux Debian package 64 bit (installer) (https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb)
4. Simply double click to Install downloaded package via Ubuntu Software

With newly installed version I can modify the Home Path:

Worked for me! Thanks :) that was definitely permission issue

[mauriau]

I'm on ubuntu, so the most simple way for me, was to uninstall dbeaver from snap and install it with the native package

[safejace]

adding a comment in 2024 that the snap package is still not working!! why does canonical/ubuntu force these packages when they can't even figure out simple permission/access like this?!?

[mroeling]

adding a comment in 2024 that the snap package is still not working!! why does canonical/ubuntu force these packages when they can't even figure out simple permission/access like this?!?

Same with the Flatpak version. That also does not work. Only solution atm that does work, is using the .deb package.