I'm using pgadmin to copy a csv file into the database.

this worked fine a million times until today. I get the following error

Could not open file "/path.csv" for reading: permission denied

I poked around google, and some of the suggestions were to disable SELinux which i don't plan on doing, since my code worked before.


what are the permissions on the path.csv file? Perhaps the file was created by a different user than usual and you don't have read permission on it. Sure sounds like a simple file permissions issue and not a DB issue.

  • You're right, for some reason, it's a different user that owns it. How stupid of me ! – dassouki Aug 19 '09 at 14:43
  • happens to all of us, far too often ;-) – Devin Ceartas Aug 19 '09 at 14:48

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.