How do I solve an error code 127 when doing a pg_dumpall through a cronjob?
If the script can work apart from a crontab, you should make sure of the following:


The script file contains the necessary environmental variables

$PGHOME
$PGDATA
$PGPORT
$PATH

Output the standard error to a file for future analysis