patternsqlCritical
Binary path in the pgAdmin preferences
Viewed 0 times
pgadminpaththepreferencesbinary
Problem
I installed PostgreSQL because I need to restore a large
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?
.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?
Solution
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
from the command line on linux/Unix systems.
A Windows example:
PostgreSQL Binary Path:
`which psql`from the command line on linux/Unix systems.
A Windows example:
PostgreSQL Binary Path:
"C:\Program Files\PostgreSQL\9.6\bin"Code Snippets
`which psql`Context
StackExchange Database Administrators Q#149169, answer score: 54
Revisions (0)
No revisions yet.