Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

please configure the postgresql binary path in the preferences dialog - how do I do this?

Asked by Aalap Prabhakaran Sep 29, 2022 2.1K views 1 answer
Share

About this 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?

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.