Date: Wed, 13 Oct 2004 19:45:36 +0400 From: dima <_pppp@mail.ru> To: Norman Uittenbogaart <norman@webminded.nl> Cc: freebsd-stable@freebsd.org Subject: Re: Postgres Message-ID: <E1CHlJo-000BOD-00._pppp-mail-ru@f27.mail.ru> In-Reply-To: <416D4546.9090308@webminded.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E1CHlJo-000BOD-00._pppp-mail-ru>