PostgreSQL Binary Path in pgAdmin 4 1.0-rc1

Question

What needs to go in the field PostgreSQL Binary Path under File > Preferences > Path > Binary paths?

Answer 1

With the latest version of PostgreSQL 9.6 running on pgAdmin 4, you will find hints under "Help" tab to this two urls after replacing $VERSION$ with the appropriate version number: https://www.enterprisedb.com/docs/en/9.6/pg/ and https://www.postgresql.org/docs/9.6/static/ (however, the links don't really give much help as such).

If you follow the hint below the box and search for "pg_dump, pg_restore" within the directory where you install PostgreSQL, they will be in the "bin" directory/folder

On windows, with default installations it is something like: C:\Program Files\PostgreSQL\9.6\bin

Copy your path and paste in the boxes under Click on "Binary paths" tab and click on "OK"

Answer 2

This needs to be a directory, not a single file. So on Windows, it's usually C:\Program Files\PostgreSQL\9.6\bin

In future versions of pgAdmin 4 there will be this hint:

Path to the directory containing the PostgreSQL utility programs (pg_dump, pg_restore etc).