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

[achenwei-chwy]

@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?

[thanhdx0]

I used pgAdmin4 instead. It's good enough too.

[rtriveurbana]

why is this closed? The problem still persist

[alykamb]

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.

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