How to run `autopostgresqlbackup` in a cron job?

Question

How to run autopostgresqlbackup in a cron job?

I setup a new cronjob this way:

34 20 * * * echo "DAILY INTERNAL BACKUP - POSTGRESQL" && sudo autopostgresqlbackup

Unfortunately this isn't working. Here is the message I received in my mailbox.

DAILY INTERNAL BACKUP - POSTGRESQL 
/bin/bash: autopostgresqlbackup: command not found

The autopostgresqlbackup is installed and working well in my server.

I want to control when backups are done through my own cron jobs, is it possible?

And this echo "DAILY INTERNAL BACKUP - POSTGRESQL" will not work rather put that into a file with >> — George Udosen, Sep 27 '17 at 23:36

George Udosen · Accepted Answer · 2017-09-27 23:48:49Z

Now your cron job won't work as is:

34 20 * * * echo "DAILY INTERNAL BACKUP - POSTGRESQL" && sudo autopostgresqlbackup

Several things there:

This echo "DAILY INTERNAL BACKUP - POSTGRESQL" won't be seen as cron runs in it's own shell
This sudo autopostgresqlbackup:
- sudo isn't needed to run cron job, since I assume your root
- autopostgresqlbackup, the full path to this command is needed to get it to run.

So your cron job might look like this:

34 20 * * * echo "DAILY INTERNAL BACKUP - POSTGRESQL" >> /var/log/postlog && /path/to/binary/autopostgresqlbackup

1 Answer 1