systemcr Posted January 11, 2020 Share Posted January 11, 2020 (edited) Hi everyone, As I explained in a former post, I'd like to schedule a cron job to run an SQL script on my PostgreSQL database for maintenance stuff. The thing is that I am receiving this error when the cron job is being executed (see image attached). Could anyone help me please? Thanks in advance! Edited January 11, 2020 by systemcr Link to comment Share on other sites More sharing options...
yashrs Posted January 11, 2020 Share Posted January 11, 2020 Please attach the error message/image. I think you missed it in the initial post Link to comment Share on other sites More sharing options...
systemcr Posted January 11, 2020 Author Share Posted January 11, 2020 Sorry, done :-) Link to comment Share on other sites More sharing options...
wolstech Posted January 11, 2020 Share Posted January 11, 2020 I’m not sure if this is possible or not. I suspect a permission issue would be the cause if it’s not. I’ll pass this to Krydos, but is there a reason you can’t just run the sql queries in a php script or something and call the script from the cron? That’s what I do for database maintenance on my systems (though I use MySQL). Link to comment Share on other sites More sharing options...
Krydos Posted January 11, 2020 Share Posted January 11, 2020 just run the sql queries in a php script or something and call the script from the cron Link to comment Share on other sites More sharing options...
Recommended Posts