Cannot start the PostgreSQL service

From: David Unsworth <dunswort(at)hotmail(dot)com>
To: "pgsql-admin-owner(at)postgresql(dot)org" <pgsql-admin-owner(at)postgresql(dot)org>, "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org>, "pgsql-in-general-owner(at)postgresql(dot)org" <pgsql-in-general-owner(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-general-owner(at)postgresql(dot)org" <pgsql-general-owner(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Cannot start the PostgreSQL service
Date: 2016-01-30 16:24:20
Message-ID: DUB110-W8187210B20142A57FC0DC8DDDC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-in-general

Hello. Sorry if I have sent this to too may mail boxes. I hope one of them is correct. Please forward this on if not.

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.

I have tried to set up pg_hba.conf correctly. Currently it is set to the following -

# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.1/5432 trust
# IPv6 local connections:
host all all ::1/128 trust

I have tried to set up pgpass.conf correctly as this was empty. Currently set to the following -

127.0.0.1:5432:*:postgres:dbpass

The errors remain. Also 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

I wanted to reload the configuration (before attempting to start the Service again ) and I got the error "Reload command returned an error (1)".

I am not sure what to try next. I have some databases I do not want to lose if I can avoid it.

Any ideas?

Thanks, Dave.


Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Kretschmer 2016-01-30 16:54:54 Re: Cannot start the PostgreSQL service
Previous Message Evan Rempel 2016-01-30 06:19:45 9.5 new setting "cluster name" and logging

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2016-01-30 16:54:54 Re: Cannot start the PostgreSQL service
Previous Message Alvaro Herrera 2016-01-30 16:24:02 Re: BRIN indexes

Browse pgsql-in-general by date

  From Date Subject
Next Message Andreas Kretschmer 2016-01-30 16:54:54 Re: Cannot start the PostgreSQL service
Previous Message Rajesh Tilwani 2016-01-30 12:18:31 New Developer wanting to get started :)