Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0495764FC39 for ; Thu, 30 Oct 2008 00:53:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89670-07 for ; Thu, 30 Oct 2008 00:53:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3CC1E64FC2A for ; Thu, 30 Oct 2008 00:53:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m9U3r0Vg004101; Wed, 29 Oct 2008 23:53:00 -0400 (EDT) To: "Peter Koczan" cc: "Alvaro Herrera" , "Scott Marlowe" , "pgsql-admin@postgresql.org" Subject: Re: SSL and md5 password? In-reply-to: <4544e0330810292026j1b8e9307j62d6a9c828c7a6b5@mail.gmail.com> References: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com> <20081029185434.GH4331@alvh.no-ip.org> <2764.1225332660@sss.pgh.pa.us> <4544e0330810292026j1b8e9307j62d6a9c828c7a6b5@mail.gmail.com> Comments: In-reply-to "Peter Koczan" message dated "Wed, 29 Oct 2008 22:26:30 -0500" Date: Wed, 29 Oct 2008 23:53:00 -0400 Message-ID: <4100.1225338780@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/178 X-Sequence-Number: 30634 "Peter Koczan" writes: > On Wed, Oct 29, 2008 at 9:11 PM, Tom Lane wrote: >> Right. So in the meantime, what Peter should do is try the problem case >> after >> export PGSSLMODE=require >> so that he can see the error message that's relevant to his desired use. > After exporting that environment variable, it works. Thanks. Huh? That makes no sense at all ... unless you had it set to "disable" before. regards, tom lane