UNIX for Dummies Questions & Answers

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

You have not used the date command properly, below is the correct one.

P4CMPlus_int_67.06.30.2010.backup

P4CMPlus_int_67.<--------->.backup

<partoffilename><date><partoffilename>

P4CMPlus_int_67.`date +'%d%m%Y'`.backup

- For redirecting the output and erros to files, in your cron entry add the below at the last
> <output filename> 2><error filename>

How does this work:

Code:

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"

Further to vishalaswani.

You have the wrong sort of quotes. Anything between single quotes will not be expanded. Use double quotes.

Just seen Scrutinizer's post which tackles both issues.

thanks methyl,Scrutinizer and vishalaswani for the inputs and help.

I am getting the date suffixed to file name, but when i take the backup dump of database(eg:P4CMPlus_int postgres) i am unable to take with the below added quotes "" modification.

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"

also tried with substituting below quotes
"/apps/cmplus/backup/daily_backup`date +P4CMPlus_int_67.%m.%d.%Y.backup`" "P4CMPlus_int"

output:
P4CMPlus_int_67.07.01.2010.backup P4CMPlus_int

Any help or clues to take the dump of this DB.

Did you try this subtle variation.

Code:

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

Which is directly comparable to the line in your parallel post.

Code:

/usr/PostgreSQL/8.3/bin/pg_dump -h <ip addr> -p 5432 -U postgres -F c -v -f '/apps/cmplus/backup/daily_backup/P4CMPlus_ZDC.backup' "P4CMPlus_ZDC"