Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aPZW6-0006gD-Ch for pgsql-general@arkaria.postgresql.org; Sat, 30 Jan 2016 17:40:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aPZW5-0003Kf-MU for pgsql-general@arkaria.postgresql.org; Sat, 30 Jan 2016 17:40:57 +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 1aPZW4-0003JJ-DJ; Sat, 30 Jan 2016 17:40:56 +0000 Received: from mail-oi0-x22d.google.com ([2607:f8b0:4003:c06::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aPZW1-0003Ld-52; Sat, 30 Jan 2016 17:40:55 +0000 Received: by mail-oi0-x22d.google.com with SMTP id r14so66161657oie.0; Sat, 30 Jan 2016 09:40:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=MLnBOuKh2wYl0y4zOdRVIIwGkjZBEeOIAhxJ7SSA5Ls=; b=WhpZbWtffcGLoLvIky9qg2VBGhoFo2QcjYIsIENXjAuhSlETQPxxf4Y4UblMrY6lC5 9O8TwNPPpTQtpLcy4VwrTKuTQ3Qd+wdGWBKDDz7TR4UYantg1r+LCXZVsFqBMUrxWzW/ C0IoCxbYfW/MU202bqGsbr6NlqJjyICLpa4WYGE+/5s+QMTzv3eFx3VH1G1iDAyI8dFr NqGJ/6sn04SNG/FgUyw232l2Ehn+bNcBUmUrA/UEBnHjI52ufbrCufCjIlae4+xSCkMC pf63l7HYp+zbIEA1azu4UD8AcoA6IAq5PuVmiiXp0IdtjTgK4jxXmQAd8/X89FOzdHwE 56rg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:content-type:mime-version:subject:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to; bh=MLnBOuKh2wYl0y4zOdRVIIwGkjZBEeOIAhxJ7SSA5Ls=; b=YlQ9py5rW0U+HZG3cAUDvdC+dt6/1sRlGew6ThvbKbJzDg2qOu9Jz42LyIkdiIwjj9 hBpFhZM6SFI4wkNL0XEhCjZ4IVKuf++IaeGqi+yNUDWN5wtFbatSg61gSXtV6/yZJwuc mG5/9yegaPLpZiuHmDbaSBQvwjRbys2sGOSMpVSQRIu9vpudseWQSL9Y7uJ5tyzxr9Yg 6H7pzGENpuyovYHvdmw2lqURXwCMZ8Ni9NeFwgLP/pkICc13fy9bD6axaQafyTKF2zpb OGdNBH6F1j0y6aiohSze6naibuYY5YxuEDXvtotuH57RKutRThPRknXe2FmJQ1Pu5EzW vltw== X-Gm-Message-State: AG10YOQ15yM3Vb7sfnWXV783FBwJzCIaVykwuIlmamBOdCoQ8JvEwSkci/w6urspXlSYRQ== X-Received: by 10.202.71.151 with SMTP id u145mr6604555oia.100.1454175652180; Sat, 30 Jan 2016 09:40:52 -0800 (PST) Received: from ?IPv6:2605:6000:f686:8500:1c25:b19a:1538:31a0? ([2605:6000:f686:8500:1c25:b19a:1538:31a0]) by smtp.gmail.com with ESMTPSA id q4sm10611300oew.6.2016.01.30.09.40.51 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 30 Jan 2016 09:40:51 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-CAA6F998-B503-4A79-A1A9-7EA41C1F61F6 Mime-Version: 1.0 (1.0) Subject: Re: [ADMIN] Cannot start the PostgreSQL service From: John Scalia X-Mailer: iPad Mail (13D15) In-Reply-To: Date: Sat, 30 Jan 2016 11:40:50 -0600 Cc: "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" Content-Transfer-Encoding: 7bit Message-Id: <3BD15A77-5B3E-4A47-B864-B34EB2EFAC94@gmail.com> References: To: David Unsworth X-Pg-Spam-Score: -0.2 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --Apple-Mail-CAA6F998-B503-4A79-A1A9-7EA41C1F61F6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable 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 nu= mber. You might wish to search setting a CIDR value, but if you want to allo= w: 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 wrote:= >=20 > Hello. Sorry if I have sent this to too may mail boxes. I hope one of th= em is correct. Please forward this on if not. > =20 > This was working until recently. In Services I right clicked on propertie= s 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 Servi= ce 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 lo= se if I can avoid it. =20 > =20 > Any ideas? > =20 > Thanks, Dave. > =20 > =20 > =20 >=20 >=20 > =20 >=20 --Apple-Mail-CAA6F998-B503-4A79-A1A9-7EA41C1F61F6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
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:
<= br>
Just 192.168.1.1 then

host   &n= bsp;      all         all     &= nbsp;   192.168.1.1/32         trust

If you want al= l the systems in 192.168.1.x then

host           a= ll        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 m= y 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 boxe= s.  I hope one of them is correct.  Please forward this on if not.=
 
This was working until recently.  In Services I right cli= cked on properties and I think I changed the METHOD in pg_hba.conf from md5 t= o trust.
I think after making this change the problems started.
 =
In Services I cannot start the PostgreSQL Server 8.4 due to Error:1069 T= he service did not start due to a logon failure.
 
I have tried t= o set up pg_hba.conf correctly.  Currently it is set to the following -=
 
# TYPE  DATABASE    USER   = ;     CIDR-ADDRESS      &n= bsp;   METHOD
# IPv4 local connections:
host  &nbs= p; all         all   =       127.0.0.1/32     &nb= sp;    trust
host    all   &= nbsp;     all       &= nbsp; 192.168.1.1/5432      trust
# IPv6 local c= onnections:
host    all      = ;   all         ::1/128&nb= sp;            &= nbsp; trust
 
I have tried to set up pgpass.conf correctly as thi= s was empty.  Currently set to the following -
 
127.0.0.1:= 5432:*:postgres:dbpass
 
The errors remain.  Also I have bee= n getting the error "could not connect to Server: Connection refused" detail= ed below -
 
http://www.pgadmin.org/docs/1.14/connect-error.html
&nbs= p;
I wanted to reload the configuration (before attempting to start the S= ervice 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.
 
 
 


 

=
= --Apple-Mail-CAA6F998-B503-4A79-A1A9-7EA41C1F61F6--