Обсуждение: Cannot start the PostgreSQL service

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.
 
 
 


 

On 01/30/2016 08:24 AM, David Unsworth wrote:
> 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.

For future reference, sending to --general would be sufficient.

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

Assuming this is a Windows machine, what version of the OS?

How did you install Postgres on this machine?

What user are you starting the service as?

What if anything happened/changed between the time it was working and
the time it stopped working?

What is in the Postgres log prior to it shutting down?

What is in the system(Windows) logs when you try to start the service?

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

I doubt you have lost the databases or will lose the databases. You are
just not able to start the server.

>
> Any ideas?
>
> Thanks, Dave.
>
>
>
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com