Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1F79C64FD39 for ; Sun, 23 Nov 2008 12:34:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51353-06 for ; Sun, 23 Nov 2008 12:34:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ij.net (mail.ij.net [207.22.166.253]) by mail.postgresql.org (Postfix) with ESMTP id 694BA64FC5C for ; Sun, 23 Nov 2008 12:34:30 -0400 (AST) Received: from godzilla.local.scalefeather.com (unverified [24.210.132.203]) by ij.net (SurgeMail 3.5b3) with ESMTP id 775392528 for multiple; Sun, 23 Nov 2008 11:34:32 -0500 Subject: Re: Can't install PG on a Windows Domain Controller From: Josh Williams To: "Abraham, Danny" Cc: pgsql-admin@postgresql.org, dabraham@Bmc.com In-Reply-To: <955C1931034B744494BA777BCC1BB94A0318F9FF@HOU-EX-10.adprod.bmc.com> References: <955C1931034B744494BA777BCC1BB94A0318F9FF@HOU-EX-10.adprod.bmc.com> Content-Type: text/plain Date: Sun, 23 Nov 2008 11:34:24 -0500 Message-Id: <1227458064.9294.17.camel@godzilla.local.scalefeather.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 Content-Transfer-Encoding: 7bit X-Server: High Performance Mail Server - http://surgemail.com r=329229864 X-Authenticated-User: joshwilliams@ij.net 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: 200811/136 X-Sequence-Number: 30790 On Sun, 2008-11-23 at 03:06 -0600, Abraham, Danny wrote: > Since PG requires a local (weak) user to own the service, > And since a DC cannot have local user, > Can I assume that we cannot install PG on a Windows DC? Nope; a domain user is effectively a "local" user when on a domain controller, so as long as you're okay with the user being in your domain it'll work fine. > We are on PG V8.2.4. BTW, since this is evidently a new install, why not go directly to 8.2.11? (Or 8.3?) ... Hmm, or is this an existing PG install on a server being promoted to a domain controller? If it's in an existing domain it'll wipe your local user list, of course, but once the account is recreated it shouldn't have any problem. > Thanks > > Danny Abraham - Josh Williams