Re: Cronjob to autobackup database

A question --

>________________________________
> From: teyking2003 <tchongking(at)hotmail(dot)com>
>To: pgsql-admin(at)postgresql(dot)org
>Sent: Wednesday, December 5, 2012 4:39 PM
>Subject: Re: [ADMIN] Cronjob to autobackup database
>
>i copy this copy inside etc/cron.daily/autopgdump.sh and put in the full
>directory path and wait until 930am. but nothing has been process.
>
>do we need to setup special permission for this .SH file?
>

If you copy the command exactly as the cron entry shows it, and, as the user who runs the cron job, paste it onto the command line and run it; what does the command do ?

If it runs from the command line, a few possibilities occur to me --

a) you didn't set the time to what you thought you did (been there, done that, easy to do).

b) Some missing part that the user's environment is providing (an ENV var, for example) but the cron job would not know about.

If it does not run from the command line, that will probably give you a clue.

HTH,

Greg Williamson