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.