Subject: Re: Cannot start the PostgreSQL service
To: Adrian Klaver <adrian.klaver@aklaver.com>,
 David Unsworth <dunswort@hotmail.com>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
 <56ACF68D.7060709@aklaver.com> <DUB110-W1384283D9F15BF52EECF130DDDC0@phx.gbl>
 <56AD17B4.80105@aklaver.com> <56AD18C3.9040605@lucee.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
From: "Igal @ Lucee.org" <igal@lucee.org>
Message-ID: <56AD1E04.9080306@lucee.org>
Date: Sat, 30 Jan 2016 12:33:08 -0800
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: <56AD18C3.9040605@lucee.org>
Content-Type: multipart/alternative;
 boundary="------------070905010203060406070300"
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

This is a multi-part message in MIME format.
--------------070905010203060406070300
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------070905010203060406070300
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 1/30/2016 12:10 PM, Igal @ Lucee.org wrote:<br>
    <blockquote cite="mid:56AD18C3.9040605@lucee.org" type="cite"><br>
      Did you check the Windows Event Viewer?  When a service fails to
      start you should see the details there in the Application log
      errors.
      <br>
    </blockquote>
    Sorry, I just realized that you had this:<br>
    <br>
    <blockquote type="cite">2016-01-25 18:45:19 GMTFATAL:  the database
      system is starting up
      <br>
      2016-01-27 01:09:47 GMTFATAL:  <b>role "SYSTEM" does not exist
      </b><br>
      pg_ctl: PID file "C:/Program Files
      <br>
      (x86)/PostgreSQL/8.4/data/postmaster.pid" does not exist
    </blockquote>
    <br>
    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)<br>
    <br>
    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.<br>
    <br>
  </body>
</html>

--------------070905010203060406070300--