Hi i am currently using below command in shell script and calling it from cron job.
This is to take daily backup with the date as suffix to the file.When i try i unable to get the date suffixed to the backup file.
Please help me as to wt's wrong in this or how to get the date added to the backup file?
and also how to redirect output to a file and errors to another. i tried using double codes, but still not working out..
The below command is in shell script:
pg_dump -h ipaddress -p 5432 -U postgres -F c -v -f '/apps/cmplus/backup/`date +P4CMPlus_int_67.%m.%d.%Y.backup`' "P4CMPlus_int"
the output iam getting is :
`date +P4CMPlus_int_67.%m.%d.%Y.backup`
the output should be:
P4CMPlus_int_67.06.30.2010.backup