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

January 27, 2019 1.2k views
PostgreSQL Django 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?

1 Answer

Was able to find the answer

Binary Path should be set to: /usr/bin

Have another answer? Share your knowledge.

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