Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aPYK3-0002a1-QP for pgsql-admin@arkaria.postgresql.org; Sat, 30 Jan 2016 16:24:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aPYK3-000477-DE for pgsql-admin@arkaria.postgresql.org; Sat, 30 Jan 2016 16:24:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aPYK2-00044D-CC; Sat, 30 Jan 2016 16:24:26 +0000 Received: from dub004-omc1s9.hotmail.com ([157.55.0.208]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aPYJy-0001ko-R9; Sat, 30 Jan 2016 16:24:25 +0000 Received: from DUB110-W81 ([157.55.0.238]) by DUB004-OMC1S9.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Sat, 30 Jan 2016 08:24:20 -0800 X-TMN: [3hn0bXcCV2ajzRAK11WBJKRXSnY+15Dl] X-Originating-Email: [dunswort@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_e8f5a340-2540-4a45-adb0-ce13ef08584d_" From: David Unsworth To: "pgsql-admin-owner@postgresql.org" , "pgsql-in-general@postgresql.org" , "pgsql-in-general-owner@postgresql.org" , "pgsql-general@postgresql.org" , "pgsql-general-owner@postgresql.org" , "pgsql-admin@postgresql.org" Subject: Cannot start the PostgreSQL service Date: Sat, 30 Jan 2016 16:24:20 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 30 Jan 2016 16:24:20.0807 (UTC) FILETIME=[AC76F570:01D15B7A] X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_e8f5a340-2540-4a45-adb0-ce13ef08584d_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello. Sorry if I have sent this to too may mail boxes. I hope one of the= m is correct. Please forward this on if not. =20 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. =20 In Services I cannot start the PostgreSQL Server 8.4 due to Error:1069 The = service did not start due to a logon failure. =20 I have tried to set up pg_hba.conf correctly. Currently it is set to the f= ollowing -=20 =20 # 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 =20 I have tried to set up pgpass.conf correctly as this was empty. Currently = set to the following -=20 =20 127.0.0.1:5432:*:postgres:dbpass =20 The errors remain. Also I have been getting the error "could not connect t= o Server: Connection refused" detailed below -=20 =20 http://www.pgadmin.org/docs/1.14/connect-error.html =20 I wanted to reload the configuration (before attempting to start the Servic= e again ) and I got the error "Reload command returned an error (1)". =20 I am not sure what to try next. I have some databases I do not want to los= e if I can avoid it. =20 =20 Any ideas? =20 Thanks=2C Dave. =20 =20 =20 =20 = --_e8f5a340-2540-4a45-adb0-ce13ef08584d_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello. =3B Sorry if I have s= ent this to too may mail boxes. =3B I hope one of them is correct. = =3B Please forward this on if not.
 =3B
This was working until re= cently. =3B In Services I right clicked on properties and I think I cha= nged the METHOD in pg_hba.conf from md5 to trust.
I think after making t= his change the problems started.
 =3B
In Services I cannot start = the PostgreSQL Server 8.4 due to Error:1069 The service did not start due t= o a logon failure.
 =3B
I have tried to set up pg_hba.conf correc= tly. =3B Currently it is set to the following -
 =3B
# TYPE&= nbsp=3B DATABASE =3B =3B =3B USER =3B =3B =3B = =3B =3B =3B =3B CIDR-ADDRESS =3B =3B =3B =3B&nb= sp=3B =3B =3B =3B =3B METHOD
# IPv4 local connections:host =3B =3B =3B all =3B =3B =3B =3B =3B&= nbsp=3B =3B =3B all =3B =3B =3B =3B =3B =3B=  =3B =3B 127.0.0.1/32 =3B =3B =3B =3B =3B = =3B =3B =3B =3B trust
host =3B =3B =3B all = =3B =3B =3B =3B =3B =3B =3B =3B all =3B&nbs= p=3B =3B =3B =3B =3B =3B =3B 192.168.1.1/5432 = =3B =3B =3B =3B =3B trust
# IPv6 local connections:
h= ost =3B =3B =3B all =3B =3B =3B =3B =3B&nbs= p=3B =3B =3B all =3B =3B =3B =3B =3B =3B&nb= sp=3B =3B ::1/128 =3B =3B =3B =3B =3B =3B = =3B =3B =3B =3B =3B =3B =3B =3B trust
 = =3B
I have tried to set up pgpass.conf correctly as this was empty. = =3B Currently set to the following -
 =3B
127.0.0.1:5432:*:postg= res:dbpass
 =3B
The errors remain. =3B Also I have been getti= ng the error "could not connect to Server: Connection refused" detailed bel= ow -
 =3B
http://www.pgadmin.org/docs/1.14/connect-error.html
 = =3B
I wanted to reload the configuration (before attempting to start the= Service again ) and I got the error "Reload command returned an error (1)"= .
 =3B
I am not sure what to try next. =3B I have some databa= ses I do not want to lose if I can avoid it. =3B
 =3B
Any id= eas?
 =3B
Thanks=2C Dave.
 =3B
 =3B
 =3B
=

 =3B

= --_e8f5a340-2540-4a45-adb0-ce13ef08584d_--