Date: Tue, 26 Oct 2004 17:51:06 +0000 (GMT) From: stable <stable@tty.ch> To: _pppp@mail.ru Cc: freebsd-stable@freebsd.org Subject: Re: Postgres Message-ID: <200410261751.i9QHp6lt075261@sku.tty.ch> In-Reply-To: <E1CHlJo-000BOD-00._pppp-mail-ru@f27.mail.ru> from "dima" at Oct 13, 2004 07:45:36 PM
next in thread | previous in thread | raw e-mail | index | archive | help
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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200410261751.i9QHp6lt075261>