Shell Programming and Scripting

yes ofcourse...

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.

sorry once again

before i execute "pg_dump bank > backup" i want to check if the backup file already exists if it does delete it else continue as u normally would.

pg_dump bank > backup { This will overwrite the file if exists and creats if not exits }

u need not put any specfic check to delete if exists

and for mailing after finishing

just put this line at the end of ur run_script


echo "BackUp Done"| sendmail ur_id

thanx is it possible for u 2 tell me how to check wether the file exists i do not want to overwrite it every time i would delete it every time if only u could tell me how

if [ -e file_name ]; then

echo "what ever u want to do"

fi

This is the script i wrote and saved it as "u.sh"
--------------------------------------------------
#!/bin/bash
PGUSER=postgres
PGPASSWORD=""
export PGUSER PGPASSWORD

pg_dump bank > backup
echo "BackUp Done"| sendmail parikshit@belgaum.tbdnet
--------------------------------------------------------------

This the output when i executed it

------------------------------------------------------------------

-bash-2.05b$ bash u.sh
': not a valid identifierPASSWORD
:command not found
pg_dump: [archchiver <db>] connection to database "bank" failed: FATAL: user "pos
" does not exist
u.sh: line 7: sendmail: command not found
: command not found
: command not found
-bash-2.05b$
----------------------------------------------------------------------

I don't know what's wrong but i can tell u when i run the following script it works fine

-------------------------------------------------------------------------------------------
#!/bin/bash
PGUSER=postgres
PGPASSWORD=""
export PGUSER PGPASSWORD
psql bank <<EOFMYSQL
vacuum analyze;
EOFMYSQL
-------------------------------------------------------------------------------------------