Date: Sat, 30 Jan 2016 17:54:54 +0100
From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
Subject: Re: Cannot start the PostgreSQL service
Message-ID: <20160130165453.GA7826@tux>
References: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl>
User-Agent: Mutt/1.5.18 (2008-05-17)
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

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.perceptron.com
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