Failed to open countries.csv

[allegrojm]

using postgresql11 and age trying the demo and following the docs but can't open the countries.csv. i.e. SELECT load_labels_from_file always returns 'error: failed to open ' the file. Tried absolute path name as in '/home/...' as well as relative as per the docs. Any ideas? Roadblocked with evaluating this project until I get past this. Hard to debug. I'm using Ubuntu 22.04, postgres11 and AGE 1.0.0, thanks for any help.

[JoshInnis]

Hi, is your session and server on the same machine? If not, which machine is the file on? Also, does your login have permissions to access the file? Absolute file paths might require permissions you account doesn't have.

[allegrojm]

Thanks for the quick feedback. The session, server, and file are all on the same machine and I gave the file 777 permissions. I suspect the file was being blocked by directory related permissions somewhere in the path, not sure yet. I'll continue to investigate that. I was able to load the file after moving it to /tmp.

[muhammadshoaib]

You can copy the file to your home directory before running the demo script. You can than use the absolute path to be sure that you are pointing out to the correct directory.

[muhammadshoaib]

Since issue doesn't exist anymore. The issue is considered resolved. We close the issue.