/o myfile - Permission Denied

[mike kaplan]

I have no idea why this isn't working.
I'm trying to direct all output from my query to a file.
I entered postgres by typing in:

> sudo su postgres

then

> psql

then entering my database:

> \c mydb

Now, I do my query as follows (example):

> select * from table \o myfile.out

And i get the error:

myfile.out: Permission Denied.

I've tried inputting a whole path as well, like this:

> select * from table \o /home/me/Desktop/myfile.out

But I still get the same problem!
I've tried \g as well, same problem.

Please help!

[rski]

Does postgresql have write permissions for these directories?

[mike kaplan]

Hi rski,

Thanks for your response. To tell you the truth, i'm not completely sure. Could you please tell me how to check this and give postgresql write permission? I thought that since i was running it as sudo I wouldnt have to worry about this.

Thanks again.

[mike kaplan]

Hi again,

Okay, so I did some searching and found this line which I executed:

postgres=# grant all privileges on database mydb to mike;

and I got the response:

GRANT

then i connected to the database

postgres=# /c mydb

tried to do my query again, but still got the same error:

dboutput: Permission denied


Thanks again for your help

[rski]

But I was talking about premissions to system directories and files.
Can postgres write to that file /home/me/Desktop/myfile.out and succesfully execute a command (not from database but from system command line)

echo 1 > /home/me/Desktop/myfile.out

[mike kaplan]

Hi rski,

I can execute this command successfully, however still no luck in postgres....... ..

thanks again for your help

[rski]

You mean postgres execute succsesfully this command 'echo > ... '? I guess postgres server is running with postgres user rights, isn't it? Does user postgres start server?

Can postgres write to any other directory from database with /o option, like for example to /tmp/ directory?