dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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