44

So I am setting up PostgreSQL on my PC by following Jose Portilla's Course on Udemy and when I had to restore a database by the name of dvdrental. It showed up the message

`Please configure the PostgreSQL Binary Path in the Preferences dialog.

What am I supposed to do now? Any and All Help is Appreciated

Omer
  • 8,194
  • 13
  • 74
  • 92
Dr Patrick Bateman MD
  • 553
  • 1
  • 4
  • 9

4 Answers4

99

I had the same problem, I leave you the steps

  1. Click Files -> preferences -> Binary path
  2. ProgresSQL Binary path: c:\Program Files\PosgresSQL\13\bin
  3. Click right DataBase-> Restore...

NOTE: https://www.youtube.com/watch?v=7cBkXKCY4Ew

francisco ameri
  • 1,006
  • 4
  • 2
28

2023 Update...

Add the path of the bin folder of PostgreSQL. For example: C:\Program Files\PostgreSQL\15\bin

For postgre

enter image description here

Omer
  • 8,194
  • 13
  • 74
  • 92
1

  1. For PostgreSQL 15, go to file>preferences>paths>binary paths.

  2. Under EDB Advanced Server Binary Path, set EDB Advanced Server 15 to C:\Program Files\PostgreSQL\15\bin

  3. And under PostgreSQL Binary Path, set PostgreSQL 15 to C:\Program Files\PostgreSQL\15\bin and set this as default.

for video guidance https://www.youtube.com/watch?v=219xC6Zhpls

musangi
  • 31
  • 4
0

If you are getting the, "Somethig went wrong" after clicking the Binary Paths Tab, Restart Your pgAdmin.

Evans Kiptoo
  • 53
  • 6