Just wondering how to go about assigning binary path to a remote server. I have pgAdmin on my personal computer, but the server (CentOS) that PostgreSQL resides on is at a different location.
Postgresql – pgAdmin 4 v1.6 setting PostgreSQL Binary Path to a remote server to clear-up “The system cannot find the path specified.” error
pgadmin-4postgresql
Related Question
- Postgresql – Binary path in the pgAdmin preferences
- Postgresql – Transferring (backup/restore) from development to an online server
- Postgresql – PgAdmin 4 – How to connect to database using unix socket via ssh tunnel
- Postgresql – Cannot do a restore using PgAdmin4 after a new install of PostgreSQL – pg_restore.exe file not found
Best Answer
You are getting this error because when using
EXPLAIN
orpg_dump
from pgAdmin, the program uses the utilities in its install directory$DIR/../runtime
orC:\Program Files (x86)\pgAdmin 4\v1\runtime
to execute these commands. You can put this location in the Postgresql binary path and continue with the operation.