Thread: Re: Error 1069: The service did not start due to a logon failure.
Please keep messages on list. > ------- Original Message ------- > From: Tommy Flewwelling <tommyflewwelling@hotmail.com> > To: Dave Page <dpage@postgresql.org> > Sent: 10/11/07, 23:07:46 > Subject: RE: [pgadmin-support] Error 1069: The service did not start due to a logon failure. > > Dave: > > Since I have used the postgres userid password for all three applications, then why am I not able to start the service- I should be able to logon? They use the same password to logon to the database server, but pgAgent run as a service and must authenticate as a *windows*user as well. That is what is failing. Regards, Dave
Hello Can someone tell me if it is possible to install only pgagent standalone ? thank you for your help and time Jonathan ----- Original Message ----- From: "Dave Page" <dpage@postgresql.org> To: "Tommy Flewwelling" <tommyflewwelling@hotmail.com> Cc: <Pgadmin-support@postgresql.org> Sent: Sunday, November 11, 2007 10:41 AM Subject: Re: [pgadmin-support] Error 1069: The service did not start due to a logon failure. > Please keep messages on list. > >> ------- Original Message ------- >> From: Tommy Flewwelling <tommyflewwelling@hotmail.com> >> To: Dave Page <dpage@postgresql.org> >> Sent: 10/11/07, 23:07:46 >> Subject: RE: [pgadmin-support] Error 1069: The service did not start due >> to a logon failure. >> >> Dave: >> >> Since I have used the postgres userid password for all three >> applications, then why am I not able to start the service - I should be >> able to logon? > > They use the same password to logon to the database server, but pgAgent > run as a service and must authenticate as a *windows* user as well. That > is what is failing. > > Regards, Dave > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >
As I said before, please keep your replies on the mailing list. I don't provide private support (unless you wish to purchase a support contract) . Tommy Flewwelling wrote: > David, I assume you mean Dave? > > I don’t mean to pester you but possibly you could tell me how pgAgent is > authenticated to run as a *windows* user as well? > > I have administrator rights, if that’s what you’re referring to. All services run as either LocalSystem or some other user account under which the service control manager starts them. If you open the Services applet from Control Panel\Administrative Tools, and look at the properties for the pgAgent service you will see it has a username and password to run under. That is the one that is wrong and must be corrected. Regards, Dave.