Eureka! I changed 127.0.0.1 for the PG's assiged IP address 192.168..... and now it works :)
Thx & cheers, P. 2012/1/16 Tom Lane <t...@sss.pgh.pa.us> > "P. Broennimann" <peter.broennim...@gmail.com> writes: > > -> The problem I am having is that I can not start pgagent. When I try: > > > cd /usr/bin > > ./pgagent hostaddr=127.0.0.1 port=5432 dbname=postgres user=postgres > > > and I get the following errors: > > > /usr/bin$ WARNING: Couldn't create the primary connection (attempt 1): > > could not connect to server: Connection refused > > Is the server running on host "127.0.0.1" and accepting > > TCP/IP connections on port 5432? > > "Connection refused" is a kernel-level error, not Postgres refusing the > connection. Either the postmaster is not actually listening on that > port, or there is a packet filter rejecting the traffic. I'd bet on the > latter given what you've said. > > regards, tom lane >
