Re: Problem with pgAgent on Ubuntu

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> "P. Broennimann" <peter(dot)broennimann(at)gmail(dot)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
>