How to create postgresql backup with snap build of dbeaver

[marco-lia-blog]

Hi!

On a new machine (ubuntu 20.04) I tried dbeaver via snap instead of the usual deb. I can access my remote databases just fine. But what I can't is to configure somehow a local client aka pg_dump to create a backup of a postgresql database.
I've found others who seem to have similar problems. What I didn't found was a solution.
No matter where I copy, or link or point, dbeaver out of snap can not use a pg_dump.
Best I achieved was an error 13.

022-03-09 13:00:01.658 - IO error: Cannot run program "/home/mape/snap/dbeaver-ce/155/pg_dump" (in directory "/home/mape/snap/dbeaver-ce/155"): error=13, Permission denied 2022-03-09 13:00:01.659 - java.io.IOException: Cannot run program "/home/mape/snap/dbeaver-ce/155/pg_dump" (in directory "/home/mape/snap/dbeaver-ce/155"): error=13, Permission denied at java.base/java.lang.ProcessBuilder.start(Unknown Source) at java.base/java.lang.ProcessBuilder.start(Unknown Source) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:199) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:273) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:78) at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) Caused by: java.io.IOException: error=13, Permission denied at java.base/java.lang.ProcessImpl.forkAndExec(Native Method) at java.base/java.lang.ProcessImpl.<init>(Unknown Source) at java.base/java.lang.ProcessImpl.start(Unknown Source) ... 7 more
That particular pg_dump is open to anyone. That same pg_dump works well called from CLI.

Did I mess up something with my snap installation?

[LonwoLonwo]

Hello @marco-lia-blog

As I can see, the main issue here is: Permission denied at java.base/java.lang.ProcessBuilder.start

Sorry, I'm not an expert on Linux systems, but maybe this discussion can be helpful? kokorin/Jaffree#61

[marco-lia-blog]

Hello @LonwoLonwo,

thx for your reply.
Indeed, although I chmod 777t the pg_dump file it also helps to change the ownership of the file.
Now I get:
…/snap/dbeaver-ce/155/pg_dump: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory" Task 'PostgreSQL dump' finished at Wed Mar 09 14:55:41 CET 2022 2022-03-09 14:55:41.308 - IO error: Process failed (exit code = 127). See error log. 2022-03-09 14:55:41.309 - java.io.IOException: Process failed (exit code = 127). See error log. at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:233) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:213) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:273) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:78) at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Somehow the snap installation of dbeaver is not really working with what's installed on the system.