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 (
**Linux RedHat 64bit**
~/.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
Last activity: Dec 22, 2021, 01:47 PM