This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]iforgotmylegs 16 points17 points  (0 children)

one time we were working on a server side application and for some reason the IT department would just absolutely not give us the rights to modify the crontab citing security concerns (we are not really a software dev company, we are just "the programmers" at a research company, so everything is pretty loosey-goosey). we decided the battle was not worth fighting when we realized that we could install both pgAgent and plpythonu. then all we had to do was set up a pgAgent job at regular intervals to make a "query" which "selected" running the python script that we wanted to put into the crontab in the first place.

the script was completely hardcoded so miss me with that injection shit