23

Please help me resolve this error

'C:\Program Files\PostgreSQL\13\pgAdmin 4\runtime\pg_restore.exe' file not found. Please correct the Binary Path in the Preferences dialog

1

eshirvana
  • 23,227
  • 3
  • 22
  • 38
Soko Nafuu
  • 241
  • 1
  • 2
  • 3
  • Not an answer to my question, but since this page came up when I was looking, I'll stick this here: If your error when validating the binary path is "shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory could not identify current directory: No such file or directory (PostgreSQL) 14.2" on a mac with homebrew, you need to shut down and re-open the app, as homebrew moved the directory when updating the app. – user6910756 May 04 '22 at 21:40

2 Answers2

52

Please set binary path by using steps mention in below screenshot. enter image description here

Rakesh Soni
  • 10,135
  • 5
  • 44
  • 51
  • 4
    Make sure you set the path for the *PostgreSQL Binary Path*, not the *EDB Advanced Server Binary Path* – Mark Cooper Oct 18 '22 at 15:18
  • 1
    What is in the screenshot is: File -> Preferences -> Paths -> Binary paths -> PosgreSQL Binary Path. Then match the version to whichever are installed and pick one to be the default. If only one is installed, and it is the one that is packaged for the OS, then it may be as simple as getting the version from `psql --version` and setting the path to `/usr/bin`. – Kevin Nov 08 '22 at 13:59
6

Configure pgAdmin->Paths->Binary paths and set

"PostgreSQL Binary Path" to

your postgres installation folder/bin.

There you should find all the executables such as (pg_dump.exe, pg_restore.exe...etc)

Heytham AlShayeb
  • 61
  • 3