Murugan G wrote:
Hello,
If anybody tried, please let me know how to run a postgresQL
function/procedure thro crontab in Linux ES 4.0
$ psql --help
This is psql 8.1.0, the PostgreSQL interactive terminal.
......
-c COMMAND run only single command (SQL or internal) and exit
......
So just put a proper invocation of psql in cron, eg something like:
0 * * * * /path/to/binary/psql -U foo -h yourhost.com -c "select bar()"
dbname 1> /dev/null
Gr,
Koen
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
