I'm trying to write a backup script for postgres and us a crontab on it. In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask for a password. Now I made the .pgpass in root's homedir (i wanted to use root's crontab) paste the password in it, chmod 400 it ... But it still asks for a password ... Does anybody know how to fix that ?
> I'm trying to write a backup script for postgres and us a crontab on it. > In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask > for a password.Do you use the correct .pgpass format? It must be like that: hostname:port:database:username:password> Now I made the .pgpass in root's homedir (i wanted to use root's > crontab) paste the password in it, chmod 400 it ... > But it still asks for a password ...Documentation claims the permissions should be 600.> Does anybody know how to fix that ?I happily use pg_dump & vacuumdb from crontab.