Search code examples
postgresqldbeaver

How to configurate the home client in dbeaver for Postgresql


I'm am tryng to import a database, however i'm getting this message :

Client home is not specified for connection

I guess that i have to configurate the cliente, however i dont't know how to fill these form, i've already tried, putting in the forms: /etc/postgresql/13/main, but does not work.

image of dbeaver


Solution

  • I was getting the error native client is not specified for connection when trying to export a database. In Terminal, ran the command which postgres resulting in /opt/homebrew/bin/postgres. Then in Dbeaver went to the database and right clicked > Edit Connection > Edit Driver Settings > choose the Native Client tab > Add Home > choose Mac HD > once that comes up hit Command + Shift + . to unhide the hidden folders. Then navigate to opt/homebrew/bin and click Open. It will find the postgres info it needs and add the home. Click OK > OK to close the pop-ups. Now I can do the export.