Hi there
My PostgreSQL 9.1 installed on an Ubuntu/64 10.04 machine is running fine.
I installed pgAgent with "sudo apt-get install pgagent" (that is probably version 3.0.1).
I executed the .sql script to create the pgagent objects in the database.
sudo su postgres
psql -d postgres
postgres-# \dn
List of schemas
Name | Owner
---------+----------
pgagent | postgres
public | postgres
(2 rows)
-> Database seems fine!
-> 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?
WARNING: Couldn't create the primary connection (attempt 2): 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?
WARNING: Couldn't create the primary connection (attempt 3): 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?
WARNING: Couldn't create the primary connection (attempt 4): 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?
Any idea?
P.S: I also tried to run pgagent with sudo..... -> The same errors!
Thanks,
P.