Sample Header Ad - 728x90

How to run recurring tasks on Postgresql without an external cron-like tool?

68 votes
4 answers
153399 views
I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent. Do you know of an "internal" alternative which wouldn't involve the external tool ? - I want to avoid security concerns with the password stored on the command line of the pgAgent. - I want to avoid any additional system configuration for hiding the password (~/.pgpass). **Postgresql 8.3**
**Linux RedHat 64bit**
Asked by Stephan (1513 rep)
Jun 6, 2013, 09:10 AM
Last activity: Dec 22, 2021, 01:47 PM