From: Igal @ Lucee.org <igal@lucee.org>
To: Adrian Klaver <adrian.klaver@aklaver.com>
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:33:08 -0800
Message-ID: <56AD1E04.9080306@lucee.org> (raw)
In-Reply-To: <56AD18C3.9040605@lucee.org>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
<56ACF68D.7060709@aklaver.com>
<DUB110-W1384283D9F15BF52EECF130DDDC0@phx.gbl>
<56AD17B4.80105@aklaver.com>
<56AD18C3.9040605@lucee.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
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.
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: igal@lucee.org, adrian.klaver@aklaver.com, dunswort@hotmail.com, pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
In-Reply-To: <56AD1E04.9080306@lucee.org>
* 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