Cron Job... Urgent

ganesh15 · August 28th, 2003, 01:47 AM

I have to do a cronjob on linux box.

The process are as below:

1. Cron job should dump postgres database to file.

2. Tar the dump file.

The problem is the database dump will take about 1 hour to dump complete.

The tar should take place once the dump is completely finish.

How do I make sure tar of the file takes place's after the database dumped completely?

Please help, its really urgent.

Regards,
ganesh

3razZz3r · September 18th, 2003, 09:10 PM

I think this should be quite simple.

Put all the commands in the script. Use cron to execute the script.
The execution should be serially unless you append "&" at the end of the command.

dikkjo · September 19th, 2003, 01:40 AM

To be sure :

Code:

pg_dump your_db > your_file && tar zcf your_tar.gz your_file

Using '&&' only execute the second command if the first one was successfully completed.

HIH
Bye