Re: Cannot start the PostgreSQL service

On 1/30/2016 12:10 PM, Igal @ Lucee.org wrote:
>
> Did you check the Windows Event Viewer? When a service fails to start
> you should see the details there in the Application log errors.
Sorry, I just realized that you had this:

> 2016-01-25 18:45:19 GMTFATAL: the database system is starting up
> 2016-01-27 01:09:47 GMTFATAL: *role "SYSTEM" does not exist *
> pg_ctl: PID file "C:/Program Files
> (x86)/PostgreSQL/8.4/data/postmaster.pid" does not exist

So you are using PostgreSQL 8.4? Not sure why you would do that on a
development machine (assuming that you're not running production servers
on Windows 7 Home)

Looks to me like the issue is that the service is running under the
Local System account, which is not recognized by PostgreSQL, and that's
why the log shows [role "SYSTEM" does not exist]. If you have installed
using the installer then you should probably have a "postgres" account
on the machine? If so, set the service to Log On as that account.