Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C824A63230A for ; Wed, 30 Jun 2010 18:54:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 74911-10 for ; Wed, 30 Jun 2010 21:54:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 9BCEC632A0C for ; Wed, 30 Jun 2010 18:54:18 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 10041348034; Wed, 30 Jun 2010 14:54:17 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ki0KuO50z+k9; Wed, 30 Jun 2010 14:54:14 -0700 (PDT) Received: from [192.168.1.100] (unknown [71.94.249.122]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id A8D2E348002; Wed, 30 Jun 2010 14:54:14 -0700 (PDT) Subject: Re: postgres database user account From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Maria.L.Wilson-1@nasa.gov Cc: "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS]" , "Plugge, Joe R." , "pgsql-admin@postgresql.org" In-Reply-To: <4C2BA55D.9000700@nasa.gov> References: <4C2B97BE.7040405@nasa.gov> <4C2BA2DF.2090900@nasa.gov> <1277928730.20538.2776.camel@jd-desktop.unknown.charter.com> <4C2BA55D.9000700@nasa.gov> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Wed, 30 Jun 2010 14:54:03 -0700 Message-ID: <1277934843.20538.2801.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201006/241 X-Sequence-Number: 35019 On Wed, 2010-06-30 at 16:13 -0400, Maria L. Wilson wrote: > and what would be those "extremely specific purposes"? Needed to modify files that are within the cluster directory (postgresql.conf) or needing to stop/start PostgreSQL which could be done with sudo without allowing login. Sincerely, Joshua D. Drake > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering