Hi Peter,
Thank you for your answer.
php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres.
Unfortunately, i can't. There's too much variables involved :(
Otherwise why not connect to postgres using the php functions and write the text file using php?
???
You might also be able to su to postgres.
This is my favourite. How can i execute this query:
$myresult2 = pg_query($pgsql_conn, "SELECT url_negado from urls_negados > /tmp/urls_negados.txt");
from inside a PHP file as user postgres ?
Thank you.
Warm Regards, Mário Gamito
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php