I want to run a query all X seconds on my PostgreSQL database (9.5 on Windows Systems).
I read that you can use Background Jobs to achieve this.
The pgAgent Jobs (https://www.pgadmin.org/docs/1.4/pgagent-jobs.html) are a good explanation on how to do this.
However on the installation page (https://www.pgadmin.org/docs/1.4/pgagent-install.html) they mention the security concerns about storing the password on the server / connection string.
Is there another way to run a query all X seconds on the database? Maybe there is an extension that works like oracle jobs?