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.

  • What do you mean by "assigning binary path to a remote server". Do you want to connect to postgresql instance running on remote server via pgadmin, or something else – Lohit Gupta Aug 8 '17 at 9:53
  • Hi, this answer has a picture showing the option I am referring to. dba.stackexchange.com/questions/149169/…. I can access the server remotely and run standard CRUD requests. However, if I try to do something like import a CSV, or EXPLAIN ANALYZE I get the error in the title. The error is related to this option in pgAdmin. The option is looking for the install location for PostgreSQL. All the examples I have seen use a local example, so curious if you can specify a remote. – eox.dev Aug 8 '17 at 15:05

You are getting this error because when using EXPLAIN or pg_dump from pgAdmin, the program uses the utilities in its install directory $DIR/../runtime or C:\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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.