X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 60DDB8B9EA6 for ; Tue, 22 Feb 2005 13:48:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66256-06 for ; Tue, 22 Feb 2005 13:48:12 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id BB8F88B9E87 for ; Tue, 22 Feb 2005 13:48:13 +0000 (GMT) Received: from demolish1 (81-6-253-170.dyn.gotadsl.co.uk [81.6.253.170]) by smtp.nildram.co.uk (Postfix) with SMTP id CCE442C0CD4 for ; Tue, 22 Feb 2005 13:48:09 +0000 (GMT) Message-ID: <008201c518e5$268d77b0$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" References: <20050222132615.GS66519@eris.tenfour> Subject: Re: pg_hba.conf Date: Tue, 22 Feb 2005 13:48:11 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/214 X-Sequence-Number: 16382 If postgres has ssl enabled then it will by default negotiate to use ssl, regardless of the host or hostssl settings in pg_hba. Your client software needs to refuse ssl connections then it will fall back to a non-ssl connection so long as there exists a host setting in pg_hba. The hostssl setting in pg_hba means that it must use ssl to connect, where as the host setting in pg_hba can mean either or, depending on your client. What client software are you using? Regards Donald Fraser ----- Original Message ----- From: "Dick Davies" To: "PostgreSQL Admin" Sent: Tuesday, February 22, 2005 1:26 PM Subject: Re: [ADMIN] pg_hba.conf > * K?PFERL Robert [0228 12:28]: > > According to the excelent doc, the _first_ matching entry will be used. > > If that were true, the below would work, surely? > > > C:\> I have this: > > C:\> > > C:\> root@eris:postgresql80-server$ cat /opt/pgsql/data/pg_hba.conf > > C:\> # TYPE DATABASE USER IP-ADDRESS METHOD > > C:\> local all all trust > > C:\> host all all 10.2.3.4/32 md5 > > C:\> hostssl all all 0.0.0.0/0 md5 > > -- > 'Interesting. No, wait, the other thing - Tedious.' > -- Bender > Rasputin :: Jack of All Trades - Master of Nuns > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >