Hi Juan If your script is running on the same machine as the postgres server then my preference is to connect using unix domain socket (that would be local in pg_hba.conf) and peer authentication so no password.
Typically I would have a system user (say dhis) which runs the tomcat container for an instance (using the 'standardised' install from dhis2-tools). That same user would have access to the database. So in the crontab for that user you can include various sql scripts which you execute at prescribed times using psql. Bob
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
