From: 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:06:12 -0800
Message-ID: <56AD17B4.80105@aklaver.com> (raw)
In-Reply-To: <DUB110-W1384283D9F15BF52EECF130DDDC0@phx.gbl>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
<56ACF68D.7060709@aklaver.com>
<DUB110-W1384283D9F15BF52EECF130DDDC0@phx.gbl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 01/30/2016 11:01 AM, David Unsworth wrote:
Ccing list, so more eyes can see.
> Hello. Thanks for the reply. Here is some more info.
>
> Assuming this is a Windows machine, what version of the OS?
> Windows 7 Home Premium
>
> How did you install Postgres on this machine?
> With Hold'em Manager software many years ago.
>
> What user are you starting the service as?
> Administrator
>
> What if anything happened/changed between the time it was working and
> the time it stopped working?
> Editing pg_hba.conf, right clicking in Services, Properties editing log
> on details. Service would not start when logging on the next day but
> was okay at the time.
So the was the machine rebooted between the time it worked and the time
it did not or did you just log out and back in?
>
> What is in the Postgres log prior to it shutting down?
> Checked pg_log folder. Log file from 2012. Nothing since the problem.
I got to believe there is a newer log file then that.
Is there more then one instance of Postgres on this machine?
>
> What is in the system(Windows) logs when you try to start the service?
> 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 there is an almost two day gap between FATAL errors. There is nothing
else between those messages or immediately prior to the first one?
>
> Previously reported errors -
>
> In Services I cannot start the PostgreSQL Server 8.4 due to Error:1069
> The service did not start due to a logon failure.
>
> I have been getting the error "could not connect to Server: Connection
> refused" detailed below -
>
> http://www.pgadmin.org/docs/1.14/connect-error.html
>
> When trying to reload the configuration (before attempting to start the
> Service again ) and I got the error "Reload command returned an error (1)".
>
>
--
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, dunswort@hotmail.com, pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
In-Reply-To: <56AD17B4.80105@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