Binary path in the pgAdmin preferences

Question

I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it's 38 million rows which was apparently too large for the person to export any other way). When I try to "restore" in pgAdmin 4 I get the message:

Please configure the PostgreSQL Binary Path in the Preferences dialog.

Is this just the path to the PostgreSQL folder? I can't find documentation on this on the PostgreSQL site. All I can find is:

Use the fields in the Binary paths node to specify paths to the PostgreSQL binary utilities and EnterpriseDB Postgres Advanced Server binary utilities.

Is there an easier way to restore the database other than through pgAdmin?

score 54 · Answer 1 · edited Sep 16 '16 at 09:33

54

Configure pgAdmin->Paths->Binary paths and set "PostgreSQL Binary Path" as shown in the screenshot. Depending on your OS and installation details, the binaries may be located elsewhere. Try

`which psql`

from the command line on linux/Unix systems.

A Windows example: PostgreSQL Binary Path: "C:\Program Files\PostgreSQL\9.6\bin"

edited Sep 16 '16 at 09:33

András Váczi

31,778
13
102
151

answered Sep 16 '16 at 08:34

Maks K.

641
4
2

score 35 · Answer 2 · edited Sep 14 '17 at 14:05

35

Select "Servers" item.
Select "Configure PgAdmin"
Enter to local path Postgresql "bin" folder.

On OSX the path is /Applications/Postgres.app/Contents/Versions/latest/bin
On Mac OSX Sierra the path was /Library/PostgreSQL/9.6/bin - I believe this is the default location from the EnterpriseDB installer for 9.6 that automatically installs PgAdmin 4.
On Linux the path is /usr/bin

edited Sep 14 '17 at 14:05

Paul White

94,921
30
437
687

answered Nov 02 '16 at 14:52

Percy Rojas

451
3
2

score 2 · Answer 3 · 2017-09-14T14:17:21.267

2

_{Community wiki answer:}

Just use pg_restore. That's all PgAdmin is doing behind the scenes.

edited Sep 14 '17 at 14:17

answered Sep 14 '17 at 14:12

Binary path in the pgAdmin preferences

3 Answers3

Linked