Shell Programming and Scripting

u have to connect to ur plsql to do th pg_dump

thats y i asked u what does pg_dump do???

and i said "u can run all those on promt right??"

u have not replied for those...

do u run pg_dump after logging on to plsql????

no i'll tell u normally this is how i do it i iniate a telnet session using windows run command

it asks me for a login : postgres

after which it does not ask for password as no password is required and it shows the bash prompt where i execute the following command pg_dump

Now i dont think psql comes into the picture anywhere

then y these in picture..

PGUSER=postgres
PGPASSWORD=""
export PGUSER PGPASSWORD

and instead of sendmail u can use mail in linux
echo "BackUp Done"| mail parikshit@belgaum.tbdnet (For this to run ur SMTP should be configured as ur sending to external system)

This is an example script which works perfectly and executes the command "pg_dump" even though the mentioned password is wrong

----------------------------------------------------------------------------
#!/bin/sh
##############################
#Script by Anas V
##############################

#Substitute your postgresql root username in the below given line
PGUSER=postgres
#Substitute your postgresql root password in the below given line
#PGPASSWORD=mypostgre
PGPASSWORD=pearls
export PGUSER PGPASSWORD

tdate=`date +%d-%b-%Y`

if [ $# -lt 1 ]

# Check if there is atleast one argument [i.e the database whose dump is to be taken]
#First argument is mandatory - Databse name
#Second argument is optional - Destination path to save dump
then

echo "Bad Arguments"
echo "-----------------------------------"
echo "USAGE : pg_dmp.sh <databasename> [outputfile]"
echo "-----------------------------------"
exit 1
else

#if one or more arguments were provided
if [ $# -ge 2 ]
#if arguments provided is greater than or equal to 2
then
#Comment out the below given file exist check and it's associated messages
# if you want to run the pg_dmpsh script to run silently. i.e from a cron or at job
# without any user interaction. Then the output dump file will be rewritten if a file
# already exists.
if [ -f $2 ]
# if destination file ie argument 2 is already existing
then
#Show confirmation message to confirm whether replace file with new one or exit
dialog --title "Confirm File Replace" --backtitle "pg_dmp.sh"\
--yesno "\nFile already exist, Do you want to replace it with '$2' file" 7 90
sel=$?
case $sel in
#if Yes then take dump and replace the existing file with new dump
0) pg_dump $1 -f $2 -i -x -O -R;;
#if No then exit
1) exit 1 ;;
#if escape then exit
255) exit 1;;
esac
else
#if destination file does not exist then create and save the dump in destination path
pg_dump $1 -f $2 -i -x -O -R
fi
else
if [ $# -eq 1 ]
#if arguments provided is equal to 1
then
if [ -d $HOME/pg_backup_$1 ]
#if folder name pg_backup_'databsename' exist in the current users home directory
then
if [ -f $HOME/pg_backup_$1/$1_$tdate ]
#if destination file name exist in pg_backup_'databasename' folder in current users home dierectory
then
#Show confirmation message for replacing the file with new dump
dialog --title "Confirm File Replace" --backtitle "pg_dump.sh"\
--yesno "\nFile already exist, Do you want to replace it with '$HOME/pg_backup_$1/$1_$tdate' file" 7 90
sel=$?
case $sel in
#if Yes then replace the file with new dump file
0) pg_dump $1 -f $HOME/pg_backup_$1/$1_$tdate -i -x -O -R;;
#if No then exit
1) exit 1 ;;
#if escape thenexit
255) exit 1;;
esac
else
#if destination file does not exist then create and save the dump
pg_dump $1 -f $HOME/pg_backup_$1/$1_$tdate -i -x -O -R
fi
else
#if folder pg_backup_'databsename' does not exist in the current users home dierectory then
#Create a new folder
mkdir $HOME/pg_backup_$1
#then create dump and save it
pg_dump $1 -f $HOME/pg_backup_$1/$1_$tdate -i -x -O -R
#if databse to take does not exist then Delete the folder created
if [ $? -ne 0 ]
then
rmdir $HOME/pg_backup_$1
fi
fi
fi
fi
if [ $# -gt 2 ]
#if arguments passed where greater than 2 then show message
then
echo "Extra Arguments ignored"
fi
fi

#reset PGUSER and PGPASSWORD
PGUSER=""
PGPASSWORD=""
export PGUSER PGPASSWORD
#End

I dont know i'm getting an error in my script which is almost the same! As u can see in the above example they are entering the username and password that i think that is necessary.

ok lets try this..

just put

pg_dump bank backup

in u.sh and run
tell me what happens..

I'm really sorry

PGUSER=postgres
PGPASSWORD=""
export PGUSER PGPASSWORD

is not required now the "pg_dump bank > backup" command works but the "dropdb bank" command does not work it says "this database does not exist"

But when i execute the same @ bash it works fine.

Wonder what could be the probs ANY WAY THANKS A BUNCH BUDDY FOR STAYING WITH ME