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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
