Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id B82CDD33CC1
	for <pgsql-admin@postgresql.org>; Tue, 12 Jun 2012 23:20:55 -0300 (ADT)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1SedCX-0000YJ-SL
	for pgsql-admin@postgresql.org; Wed, 13 Jun 2012 02:20:54 +0000
Received: by dady13 with SMTP id y13so270409dad.19
	for <pgsql-admin@postgresql.org>; Tue, 12 Jun 2012 19:20:40 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:x-gm-message-state;
	bh=xiovAnHKr4nCcCZGhWedDwXbj83uAaALZ+l1xjQZZFE=;
	b=WDVoHa/qao2N4CCKpTY3K0kX1tOG+rXfSnjoyE9ki+l85vZo3dN3dCW8XScbNvBVNs
	hJCbSxmWyaFSxHGhqx3Jge7+BFAPyN977npBCPtluj+E62j8BGmRpiRokvWh3Em+50GL
	gNfgD6kdt4SiiNinuYFww3UUZuTyVv/9uKREw240L7N1IaEv8JzlcGhU9YaxH/CepyIE
	Ut+lzaKg0Gv8JtB4XeUT9XiG7fdm7yKUUavl67UsQllIK9XHwqRBSQA7rgfENRmvP/nk
	5v+C4lh/jkEnGCAtFgBLe4dRyN8/qMOOAoo3y3fckTGyfVF2aLwkYdJr08ROHgYEM1aI
	UPHg==
Received: by 10.68.130.67 with SMTP id oc3mr2800658pbb.18.1339554040486;
	Tue, 12 Jun 2012 19:20:40 -0700 (PDT)
Received: from ayaki.localdomain (office1.postnewspapers.com.au.
	[150.101.171.128])
	by mx.google.com with ESMTPS id vp4sm3989503pbc.61.2012.06.12.19.20.37
	(version=SSLv3 cipher=OTHER); Tue, 12 Jun 2012 19:20:39 -0700 (PDT)
Message-ID: <4FD7F8F2.1070101@ringerc.id.au>
Date: Wed, 13 Jun 2012 10:20:34 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Peter Cheung <Pcheung@sfcu.org>
CC: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: How to setup PostgreSQL using Windows Authentication?
References: <583566AE01BD5948A12C964BD739A9A24686BA6A@HARRY.sfcu.intr>
	<4FD6F9AE.9000203@ringerc.id.au>
	<583566AE01BD5948A12C964BD739A9A24686BFFC@HARRY.sfcu.intr>
In-Reply-To: <583566AE01BD5948A12C964BD739A9A24686BFFC@HARRY.sfcu.intr>
Content-Type: multipart/alternative;
	boundary="------------010309070402020600040101"
X-Gm-Message-State: 
 ALoCoQnMwhPVNxMnx/CR1b1Sdvjb9eqBrvwJrNccbQjtHTRcsCNz3rF39t/nhKR4chxnHuGExvIN
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/69
X-Sequence-Number: 39660

This is a multi-part message in MIME format.
--------------010309070402020600040101
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 06/13/2012 02:37 AM, Peter Cheung wrote:
>
> According to 
> http://www.postgresql.org/docs/9.1/static/auth-methods.html, SSPI only 
> works when GSSAPI is available and GSSAPI support has to be enabled 
> when PostgreSQL is built.   Does it mean that I need to uninstall 
> PostgreSQL and reinstall it with GSSAPI support?  I used the One click 
> installer downloaded from http://www.postgresql.org/download/windows 
> to install PostgreSQL and I'm not sure how to include GSSAPI support.
>

While I haven't used it myself, I'd be amazed if the one-click 
installer's version of Pg wasn't built with GSSAPI and SSPI support. You 
shouldn't have to do anything.

--
Craig Ringer

--------------010309070402020600040101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 06/13/2012 02:37 AM, Peter Cheung
      wrote:<br>
    </div>
    <blockquote
      cite="mid:583566AE01BD5948A12C964BD739A9A24686BFFC@HARRY.sfcu.intr"
      type="cite">
      <meta http-equiv="Context-Type" content="text/html;
        charset=us-ascii">
      <div>
        <p><span>According to </span><a moz-do-not-send="true"
            href="http://www.postgresql.org/docs/9.1/static/auth-methods.html">http://www.postgresql.org/docs/9.1/static/auth-methods.html</a>,
          SSPI only works when GSSAPI is available and GSSAPI
          <span lang="EN">support has to be enabled when <span>PostgreSQL</span>
            is built.&nbsp;&nbsp; Does it mean that I need to uninstall PostgreSQL
            and reinstall it with GSSAPI support?&nbsp; I used the One click
            installer downloaded from
            <a moz-do-not-send="true"
              href="http://www.postgresql.org/download/windows">http://www.postgresql.org/download/windows</a>
            to install PostgreSQL and I&#8217;m not sure how to include GSSAPI
            support. </span></p>
      </div>
    </blockquote>
    <br>
    While I haven't used it myself, I'd be amazed if the one-click
    installer's version of Pg wasn't built with GSSAPI and SSPI support.
    You shouldn't have to do anything.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------010309070402020600040101--