Hi friends this is first post i am very new to shell scripting so i require your expertise to do the following thank u

I need to write a shell script which will run the following commands

pg_dump bank > backup(Enter)
Wait for bash prompt to appear coz it indicates that the command is executed

dropdb bank(Enter)
Wait for bash prompt to appear coz it indicates that the command is executed

createdb bank(Enter)
Wait for bash prompt to appear coz it indicates that the command is executed

psql bank < backup(Enter)
Wait for bash prompt to appear coz it indicates that the command is executed

I need to run it as a cron demon plz also let me know how to put this as a cron so that it executes every time system starts Thanks in advance

U can Put all those in a file and give it Execute Permission

"Wait for bash prompt to appear coz it indicates that the command is executed" Only when a commond get executed it goes to the next command

And of Corntab

u can add an entry this way


@reboot run_script

where run_script is ur script...

First of all thanks



How do i do it

let me ask one question

what does ur "pg_dump bank > backup" do??

is pg_dump is a shell script with "bank" as command line arg... ??

"pg_dump bank > backup" takes the backup of the database which may take some time only after the process is complete can i run the run the next command that is "dropdb bank" which deletes the database.

u can run all those on promt right??

u can do this

File run_script----

#! /bin/ksh
pg_dump bank > /input_path/backup
dropdb bank
createdb bank
psql bank < /input_path/backup


$chmod u+x run_script


$crontab -e
It Opens a file in that at the end give the following entry

@reboot /full_path_where_ur run_script_is_saved/run_script

"input_path" means where u want to take the backup right ?

Aneways thanx a bunch budy i'll try it out and let u know. 1 more thing i wanted to know about cron do i have to put my file in the cron.hourly or cron.daily folder or just crontab -e and do what u said and how do send myself an email from cron - the tasks the script has performed.