Importing CSV files into pgAdmin 4 - Utility Not Found - Ubuntu 18.04

I am unable to import my CSV files into my PgAdmin 4 in Server Mode.

I have successfully completed How To Install and Configure pgAdmin 4 in Server Mode, which is working great.

Additionally, I have migrated my Django models successfully, which are showing up within my pgAdmin in Server Mode. Again, this is working great.

However, when I go to import the csv files into pgAdmin to populate the Django models, I am getting prompted with a Utility Not Found Error: File Not Found

I HAVE GONE THROUGH THE PROCESS ON CONFIGURATION TO SET UP THE BINARY PATH TO DIFFERENT PATHS including “/var/lib/postgreql/database.bak”, ‘/etc/postgresql/10/bin’, and several other variations. There is no issue with inputting the path, but I am not creating the correct one.

“Please correct the Binary Path in the Preferences dialog”

The answers I have found online, are only providing guidance for local server settings (i.e. C:/ProgramFiles/postgresql/10/main/bin) and do not cover the Digital Ocean server that was created. All information that I can find related to Digital Ocean are on creating backups, migrating data and DO NOT DIRECTLY COVER THIS ISSUE.

Has anyone resolved this question? Do you know how I can find the correct binary path to import my csv files?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Was able to find the answer

Binary Path should be set to: /usr/bin