Execution command is not working correctly

Question

I have this command in the crontab

 bash /opt/database/pg_backup_rotated.sh -c /opt/database/pg_backup.config >> /opt/data/logs/daily-database_dump.log 2>&1

and in the.bashrc I have PG_PASSWORD supplied for the backup user. The crontab stops by asking password while executing the above command through the terminal and works fine (it does not ask for a password). What is wrong?

I am using instructions from there to backup: https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux

Answer 1

If you're using pg_dump in your backup script, it can read from ~/.pgpass in the home directory of the calling user. So create a ~/.pgpass file with the password in it.

hostname:port:database:username:password

For example:

localhost:5432:application_production:application:OukaaKu9oleif4Oomee2Gubaw9shie7h

Here's the documentation about that file.