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 6FD2B8B9C33 for ; Tue, 22 Feb 2005 14:25:21 +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 79915-02 for ; Tue, 22 Feb 2005 14:25:15 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id B74F38B9B16 for ; Tue, 22 Feb 2005 14:25:17 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1D3ayS-0004j6-Vz; Tue, 22 Feb 2005 14:25:17 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1D3ayS-0009f8-Ny; Tue, 22 Feb 2005 14:25:16 +0000 Date: Tue, 22 Feb 2005 14:25:16 +0000 From: Dick Davies To: Donald Fraser Cc: PostgreSQL Admin Subject: Re: pg_hba.conf Message-ID: <20050222142516.GU66519@eris.tenfour> Reply-To: Dick Davies References: <20050222132615.GS66519@eris.tenfour> <008201c518e5$268d77b0$0264a8c0@demolish1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <008201c518e5$268d77b0$0264a8c0@demolish1> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.495 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/217 X-Sequence-Number: 16385 * Donald Fraser [0257 13:57]: > 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? psql and ignorance :)- though it'll be ruby-postgres for the webapp. Thanks for the explanation. -- 'This must be Thursday. I never could get the hang of Thursdays.' -- Arthur Dent Rasputin :: Jack of All Trades - Master of Nuns