HowTo pg_dump with no password
Ever wanted to have pg_dump running via cron?
Well… now you can!
Create a file called .pgpass in your user directory
and put following content inside:
localhost:5432:db_name:db_login:db_pass****
Note: might also be useful to put permissions right:
chmod 0600 ~/.pgpass