From: | "P(dot) Broennimann" <peter(dot)broennimann(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with pgAgent on Ubuntu |
Date: | 2012-01-16 18:05:38 |
Message-ID: | CACm4aU8L2sAn0eKNshf+RXoxhYcX5Fq2Fdku+tFhr6Cx8GDQGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-01-16 18:11:36 | Re: Problem with pgAgent on Ubuntu |
Previous Message | salah jubeh | 2012-01-16 17:44:16 | Re: psql - TYPE DEFINITION |