From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
Date: Sat, 30 Jan 2016 17:54:54 +0100
Message-ID: <20160130165453.GA7826@tux> (raw)
In-Reply-To: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
David Unsworth <dunswort@hotmail.com> wrote:
>
> This was working until recently. In Services I right clicked on properties and
> I think I changed the METHOD in pg_hba.conf from md5 to trust.
> I think after making this change the problems started.
>
> In Services I cannot start the PostgreSQL Server 8.4 due to Error:1069 The
> service did not start due to a logon failure.
Server start has nothing to do with pg_hba.conf. And: 8.4 is out of
support.
Is this a Windows-System? I'm guessing you have problems with
anti-virus-software and/or firewall-software and/or wrong
system-user-permissions to start the service.
pg_hba.conf is for client-access, not for startup!
Maybe this here can help you:
http://www.postgresql.org/message-id/F4C27E77F7A33E4CA98C19A9DC6722A2062AD78B@EXCHANGE.corp.perceptr...
and
http://www.postgresql.org/message-id/4C2940FC.6000108@enterprisedb.com
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
--
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: akretschmer@spamfence.net, pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
In-Reply-To: <20160130165453.GA7826@tux>
* 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