I am seeing a bizarre behavior. The command works fine when called directly from prompt, but when invoked via cron, there is no output nor mail.
This works fine: script 2>&1 | tee /tmp/ff ; mailx -s "email" -myem...@company.com < /tmp/ff Now, I place the identical line in crontab file and the output file /tmp/ff does not get generated. Inside script, i am running a pg_restore which dumps output to stdout. The usage of tee is the only way to cause it to go into a file. Any idea here? Thanks On Mon, Nov 23, 2015 at 3:29 PM, Melvin Davidson <melvin6...@gmail.com> wrote: > You could also try tweaking the following attached backup script. > Caution, I wrote this quickly from a skeleton script and has not been > tested. > > On Mon, Nov 23, 2015 at 3:21 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> anj patnaik <patn...@gmail.com> writes: >> > My cron tab entry: >> >> > 0 20 * * * db_backup.sh 1> /dev/null 2>&1 | mail -s "backup cron" >> > myem...@comp.com >> >> > I am re-directing stderr to stdout and then sending that to email. >> >> Uh, read it again: you're redirecting stdout to /dev/null and then >> redirecting stderr to go where stdout goes. So all output is >> going to the bit bucket, not the pipe. >> >> regards, tom lane >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >
