Re: pgagent install to other than default port

Thanks Dave. I had tried that once but by then I had changed some other things, Including trying 127.0.0.1:3247. On your post I went back and carefully reset everything the way it was before and then added the port parm again and everything worked.

Thanks!

Jon A. Barry
Mayo Clinic
Research Computing Services
Data Base Systems Administration
(507)284-8837

-----Original Message-----
From: Dave Page [mailto:dpage(at)pgadmin(dot)org]
Sent: Thursday, May 08, 2014 3:14 AM
To: Barry, Jon A.
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] pgagent install to other than default port

On Wed, May 7, 2014 at 8:54 PM, Barry, Jon A. <barry(dot)jon(at)mayo(dot)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