From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igal @ Lucee.org <igal@lucee.org>
To: David Unsworth <dunswort@hotmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Cannot start the PostgreSQL service
Date: Sat, 30 Jan 2016 12:40:25 -0800
Message-ID: <56AD1FB9.1070808@aklaver.com> (raw)
In-Reply-To: <56AD1E04.9080306@lucee.org>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
<56ACF68D.7060709@aklaver.com>
<DUB110-W1384283D9F15BF52EECF130DDDC0@phx.gbl>
<56AD17B4.80105@aklaver.com>
<56AD18C3.9040605@lucee.org>
<56AD1E04.9080306@lucee.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 01/30/2016 12:33 PM, Igal @ Lucee.org wrote:
> 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)
From a previous post by the OP:
"How did you install Postgres on this machine?
With Hold'em Manager software many years ago. "
>
> 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.
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, igal@lucee.org, dunswort@hotmail.com, pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
In-Reply-To: <56AD1FB9.1070808@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox