Re: Problem with pgAgent on Ubuntu

Поиск
Список
Период
Сортировка
От P. Broennimann
Тема Re: Problem with pgAgent on Ubuntu
Дата
Msg-id CACm4aU_jztYWyMG48D=HWwcK6ZyZ7ZLMu0Fbw43hZuoureW7GQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with pgAgent on Ubuntu  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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@sss.pgh.pa.us>
"P. Broennimann" <peter.broennimann@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [ADMIN] PG synchronous replication and unresponsive slave
Следующее
От: Tore Halvorsen
Дата:
Сообщение: Re: Getting all entries in a single block with ctid