I have the command below and run it succesfully:/usr/lib/postgresql/9.1/bin/pg_dump -U dspace --format=c --file=/dspacebkp/dspace_db_$(/bin/date +\%m\%d\%Y)_uncompressed dspaceI can see my new file in my dspacebkp directory, which is  dspace_db_01272015_uncompressed.I want to backup the database every now and then, that's why I use cron.* * * * * /usr/lib/postgresql/9.1/bin/pg_dump -U dspace --format=c --file=/dspacebkp/dspace_db_$(/bin/date +\%m\%d\%Y)_uncompressed dspaceI made .pgpass file in /root/ to allow pg_dump without manually entering a password. I followed this link. I was wondering , why I wasn't able to successfully create the backup file. Where am I missing?Below is my .pgpass file:#hostname:port:databse:username:password*:*:dspace:dspace:fdkslaulwPS : I did not see any errors.
Pg_dump does not work in Cron
bash;shell;cron;postgresql