On Wed, 2008-03-12 at 14:22 -0400, Lee Hachadoorian wrote:
> It was far stupider than that. I had been playing around with a
> couple of different data clusters before doing a complete reinstall of
> PostgreSQL. I just realized I was trying to start a cluster that I
> was no longer using and the postgres account didn't have appropriate
> permissions for. It's one of those things where once you ask the
> question, you realize that the answer is implicit in the question.
>
> But a useful followup question is, how do I make this start itself
> when Windows starts? The service is set up to run as postgres and
> execute
>
> "C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
> "pgsql-8.3" -D "C:\Program Files\PostgreSQL\8.3\data\"
>
> This *is* pointing to the right data cluster (which I'm able to start
> successfully from the command line), but it's not starting
> automatically (even though it's configured to) and when I try to start
> it manually within the Component Services Manager, it generates the
> following error:
>
> Error 1069: The service did not start due to a logon failure.
>
The error message tells you exactly what the problem. The service
account specified for the service cannot log in. It's either the wrong
password, the wrong username, or the account is disabled/expired.
//Magnus