Shell Programming and Scripting

hi friends,

i have script to take backup of postgresql server ....i am getting error like access denied


myscript.sh
sendEmail=/home/backup/scripts/sendEmail.pl
DAY=`/bin/date +%d-%m-%y`
DIR=/home/backup/psql/$DAY
test -d $DIR | mkdir -p $DIR
dblist="test test1 postgres"
for db in $dblist
do
pg_dump $d > $DIR/$db.out
done

getting error

./myscript.sh: line 13: /home/backup/psql/11-08-08/test.out: Permission denied
./myscript.sh: line 14: /home/backup/psql/11-08-08/test1.out: Permission denied
./myscript.sh: line 15: /home/backup/psql/11-08-08/postgres.out: Permission denied


please help me to solve this error

I havnt used postgres in along time but I would guess it need a username and password...

Try something like this:

Code:

echo -n -e "username\npassword\n" | pg_dump -u -v dbname > dbname.pgdump

This is insecure, as your password is briefly visible in a full ps output,
but it works non-interactively, so you can do it in scripts (e.g., from
cron). Of course, that's potentially even more insecure...


EDIT: I cant tell if the error is with the database connect or if the user you are using has permission to write the the /home/backup/psql/11-08-08 directory.

Im thinking that if it were a db error you would get:

Code:

Connection to database 'dbname' failed.

So check write permissions for the directory.

thanks for reply ....
i have already assigned all permission to postgres user.
This script working in its home(/var/lib/postgres) directory but not in /home/backup/psql.
postgres user can able creat folder as well as file in /home/backup/psql directory

It appears that the user doesnt have permittion to either run pg_dump or write to the directory.

And you should put the full path name for pg_dump in the script.

/path/to/pg_dump $d > $DIR/$db.out

thank for reply..
I am running script using postgres user.....he is owner of /home/backup/pqsl folder...i think its not permission problem.
i have already tried using full path.

You getting "Permission denied" so its a permission problem somewhere.

finally i got problem ..
i have two hard drive as well as two partion
/dev/sda1 contain all / folder excluding /home
/dev/sdb1 contain /home
pg_sql not able to dump data on /home but it can able to dump data on other /folders

Please help me to solve this issue now