Postgres

[stable]

if the perms really need to be 600 i would do this (anyway i dont
see a reason why other users should access /root)

chmod 700 /root
chmod 600 /root/.pgpass

also check the ownership of these files

--
> 
> > 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.
> _______________________________________________
> freebsd-stable at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
>