Re: [pgadmin-support] pgAgent and pgpass

2010-04-27 Thread Dave Page
On Tue, Apr 27, 2010 at 4:19 PM, Barry Schatz wrote: > I didn't receive a copy of my post from yesterday so I'm having to write > this as if it were a new post rather than a follow-up (keeping same subject > line). Gmail hides it for you. > FYI: I overcame the problem of pgAgent not reading .pgp

[pgadmin-support] pgAgent and pgpass

2010-04-27 Thread Barry Schatz
I didn't receive a copy of my post from yesterday so I'm having to write this as if it were a new post rather than a follow-up (keeping same subject line). FYI: I overcame the problem of pgAgent not reading .pgpass by eliminating the host address from the arguments, thus: DAEMON_ARGS="-l 1 -s /va

[pgadmin-support] pgAgent and pgpass

2010-04-26 Thread Barry Schatz
First post here, hello all. I've run into a vexing problem where pgagent log reports: DEBUG: Creating primary connection DEBUG: Creating DB connection: hostaddr=xx.xx.xxx.xxx port=6543 dbname=postgres user=postgres WARNING: Couldn't create connection: fe_sendauth: no password supplied DEBUG: Clea