How to pass in password to pg_dump?
- by Mark
I'm trying to create a cronjob to back up my database every night before something catastrophic happens. It looks like this command should meet my needs:
pg_dump dbname | gzip > $(date +%Y-%m-%d).psql.gz
Except after running that, it expects me to type in a password. I can't do that if I run it from cron. How can I pass one in automatically?