Thread: Cannot start the PostgreSQL service

Cannot start the PostgreSQL service

From
David Unsworth
Date:
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.
 
 
 


 

Re: Cannot start the PostgreSQL service

From
John Scalia
Date:
The settings in you pg_hba.conf aren't really correct. The second line won't work at all. The max value after the "/" is 32. This is not for the port number. You might wish to search setting a CIDR value, but if you want to allow:

Just 192.168.1.1 then

host          all         all         192.168.1.1/32         trust

If you want all the systems in 192.168.1.x then

host           all        all         192.168.1.0/24        trust

If you want all the systems in 192.168.x.x then

host           all       all          192.168.0.0/16       trust

Hope this helps,
Jay

Sent from my iPad

On Jan 30, 2016, at 10:24 AM, David Unsworth <dunswort@hotmail.com> 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.
 
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.
 
 
 


 

Re: [GENERAL] Cannot start the PostgreSQL service

From
Adrian Klaver
Date:
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