Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 63997AD7E2F for ; Sun, 17 Jun 2012 06:34:59 -0300 (ADT) Received: from mail-bk0-f46.google.com ([209.85.214.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SgBsm-0008NT-6r for pgsql-admin@postgresql.org; Sun, 17 Jun 2012 09:34:58 +0000 Received: by bkcji2 with SMTP id ji2so3313422bkc.19 for ; Sun, 17 Jun 2012 02:34:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=chrullrich.net; s=google; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=0w2Qxw8L57GhZ6gintGQVUgJx6XMhrNFoVyCv9ChpAQ=; b=vMaatJHrTovDomCX+cCR1K8hbbDSDHOP2q7UUFBUH6KaZpS3B6zlUq+PBt6NhpU0Qg xfu9Sh6U2j5GuAcPSsLfdYD2d/qpKPGRANJtRXU6RRBc9O9PA9oB0vy9StSyW4TfhD4D qExq3yHKSsz5v3ZKzN646WJj+kefHRT7+GN4k= 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:content-transfer-encoding :x-gm-message-state; bh=0w2Qxw8L57GhZ6gintGQVUgJx6XMhrNFoVyCv9ChpAQ=; b=Spiqz4A/p1mYK/qxeUDK+hqVgWt/m0NGKZ5UI0tVsvrUNMkBwuetKF7qiyCbF8M/Qf 9+CCu8dcFiLqR1bh6gAundzzru3Cdpvb6zZaE2ScsqmwSpSxksxy0mPr25jk8ygSAnTk ZdOklRARZJ64g7HQEmpSdd8aoNzuJZoQWqFUZ/0JIAaRXq2mMoMIezoRNlI4Pr0DGJI7 gzzCXZeOk5Yeb0NcS1qAu61xQEbszfjSQZmTBGBlnOQxD95mrANT5XIwUduXuJ9O3Yeq 6BZNIOWNXK6Ouxq0D81bFzU5yFAeJE5l3HQxTSt9rIFBTylPMi4Sx46/webWhBiSgkbZ xj/w== Received: by 10.204.152.13 with SMTP id e13mr5173525bkw.46.1339925682825; Sun, 17 Jun 2012 02:34:42 -0700 (PDT) Received: from [192.168.2.23] (p5081B730.dip.t-dialin.net. [80.129.183.48]) by mx.google.com with ESMTPS id e20sm14866096bkv.10.2012.06.17.02.34.41 (version=SSLv3 cipher=OTHER); Sun, 17 Jun 2012 02:34:42 -0700 (PDT) Message-ID: <4FDDA4AD.1050905@chrullrich.net> Date: Sun, 17 Jun 2012 11:34:37 +0200 From: Christian Ullrich User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20120614 Thunderbird/13.0.1 MIME-Version: 1.0 To: Craig Ringer CC: pgsql-admin@postgresql.org Subject: Re: How to setup PostgreSQL using Windows Authentication? References: <583566AE01BD5948A12C964BD739A9A24686BA6A@HARRY.sfcu.intr> <4FDDA3A8.4030307@ringerc.id.au> In-Reply-To: <4FDDA3A8.4030307@ringerc.id.au> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQkLdCvrjwpLHUpuNKYaPWdej3g8IUvtufc7Sv2SOhD9SspXmYYzf1biO4V1p+j/bR5pq+mY X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201206/79 X-Sequence-Number: 39670 * Craig Ringer wrote: > On 06/16/2012 08:36 PM, Christian Ullrich wrote: >> The one-click installer (assuming you used that) left you with >> PostgreSQL running under a local account named "postgres". First, you >> have to change that, because SSPI requires that the service uses a >> domain account: > > That's a great explanation. I didn't see anything equivalent in the docs > - am I just blind? It's not in the main docs, at least. > If not documented anywhere I'd like to add that to the wiki. Sure, go ahead. -- Christian