Postgres Pro
Downloads
Home   >   mailing lists

Re: pgagent install to other than default port - Mailing list pgadmin-support

From Dave Page
Subject Re: pgagent install to other than default port
Date
Msg-id CA+OCxoz-uciby8qNXw_fpJ_VfAKFbSHh8hvaLxkpBM0QmpK-=A@mail.gmail.com
Whole thread Raw
In response to pgagent install to other than default port  ("Barry, Jon A." <barry.jon@mayo.edu>)
Responses Re: pgagent install to other than default port
List pgadmin-support
Tree view 
On Wed, May 7, 2014 at 8:54 PM, Barry, Jon A. <barry.jon@mayo.edu> wrote:
> Just installed pgagent. Postgres install was according to some 3rd party
> software and it installed with a non-default port.
>
>
>
> The agent insists on using the default port(I see that in the alerts  when
> the windows service is started: It wants port 5432). So... the agent will
> not connect to the database.
>
>
>
> Is there a port parameter to the agent service install?

Per the docs (http://www.pgadmin.org/docs/1.18/pgagent-install.html),
one of the parameters is the database connection strong:

pgAgent INSTALL <serviceName> [options] <connect-string>

So you can specify the port there, e.g:

"C:\Program Files\pgAdmin III\pgAgent" INSTALL pgAgent -u postgres
hostaddr=127.0.0.1 port=6543 dbname=postgres user=postgres

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: "Barry, Jon A."
Date:
Subject: pgagent install to other than default port
Next
From: Roland van der Veen
Date:
Subject: Slony on Windows 7 64 bit