After running pgAgent with the following command:
/usr/bin/pgagent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres
The pertinent debug message said:
WARNING: Couldn't create connection: fe_sendauth: no password supplied
Why do I need a password for the postgres account when on the local
machine?
I even tried the command su - postgres to make sure the postgres
account was not corrupted. It is fine.
Chuck
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
