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:dp...@pgadmin.org] Sent: Thursday, May 08, 2014 3:14 AM To: Barry, Jon A. Cc: pgadmin-support@postgresql.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....@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
