Postgres

[dima]

> 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.