Copy Command error

[[deleted]]

Hi everybody,

when i try to copy data from text file to my database iam getting error saying..

ERROR: COPY command, running in backend with effective uid 26,
could not open file '/root/result.txt' for reading.
Errno = Permission denied (13).

so i have changed my file permissions like this...

-rwxrwxrwx 1 root root 168 Jul 28 12:18 result.txt

can u suggest me any one to solve this problem

Thanks in Advance

Tulasi

[kevinsequeira]

when you are using php to create files, access files etc it runs under the webserver user, usually user apache. so change direcctory permissions to apache not root

reg
kevin

[chriskl]

Assuming you're using PostgreSQL, you need to do that as a database superuser.

Chris