Обсуждение: pgagent install to other than default port
<div class="WordSection1"><p class="MsoNormal">Just installed pgagent. Postgres install was according to some 3<sup>rd</sup>party software and it installed with a non-default port.<p class="MsoNormal"> <p class="MsoNormal">The agentinsists 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.<p class="MsoNormal"> <p class="MsoNormal">Is there a port parameterto the agent service install?<p class="MsoNormal"> <p class="MsoNormal">For the record this is on Windows server2008 R2 running Postgres Server 8.3<p class="MsoNormal"> <p class="MsoNormal"><b><span style="font-size:26.0pt;font-family:"FreestyleScript"">Jon A. Barry</span></b><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">MayoClinic</span><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">ResearchComputing Services</span><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">DataBase Systems Administration</span><p class="MsoNormal"><spanstyle="font-size:12.0pt;font-family:"Arial","sans-serif"">(507)284-8837</span><p class="MsoNormal"> </div>
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
Thanks Dave. I had tried that once but by then I had changed some other things, Including trying 127.0.0.1:3247. On yourpost I went back and carefully reset everything the way it was before and then added the port parm again and everythingworked. Thanks! Jon A. Barry Mayo Clinic Research Computing Services Data Base Systems Administration (507)284-8837 -----Original Message----- From: Dave Page [mailto:dpage@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.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