Re: Cannot start the PostgreSQL service

David Unsworth <dunswort(at)hotmail(dot)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°