Re: Error 1069: The service did not start due to a logon failure.

> ------- Original Message -------
> From: Tommy Flewwelling <tommyflewwelling(at)hotmail(dot)com>
> To: pgadmin-support(at)postgresql(dot)org
> Sent: 10/11/07, 04:22:09
> Subject: [pgadmin-support] Error 1069: The service did not start due to a logon failure.
>
> Hello,
>
> I’m trying to populate and install pgAgent (which I was able to do) however, when I try to start pgAgent service from the control panel I get the following error.
>
> Windows could not start pgAgent service on the local computer. Error 1069: The service did not start due to a logon failure.

That's the service failing to logon to windows itself. Check the password in the Services control panel applet.

> This leaves me to wonder how pgAgent is interconnected to PostgreSQL. i.e. – initdb, pg_ctl, createdb and psql?
>
> For sake of argument, when createdb, psql and pgAgent are populated do/can they share the same password?
>
> -U postgres -p 5432 -E UTF8 -q myDatabase
> -U postgres -p 5432 -q myDatabase –f docitt_db_06_setup.sql myDatabase
> INSTALL docitt-agent-1.8 -u docitt_server -p secret hostaddr=127.0.0.1 dbname=docitt_db user=postgres
>
> Any pointers regarding this error would be greatly appreciated.

Not sure what you mean by populated, but typically you would use the postgres userid password for all the above (until you start thinking seriously about security and seperation of roles anyway).

Regards, Dave