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 <tgl@xxxxxxxxxxxxx>
"P. Broennimann" <peter.broennimann@xxxxxxxxx> writes:"Connection refused" is a kernel-level error, not Postgres refusing the
> -> 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. 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
