pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: jd@commandprompt.com <jd@commandprompt.com>
Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS] <m.l.wilson@nasa.gov>
Cc: Plugge, Joe R. <JRPlugge@west.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres database user account
Date: Wed, 30 Jun 2010 16:13:17 -0400
Message-ID: <4C2BA55D.9000700@nasa.gov> (raw)
In-Reply-To: <1277928730.20538.2776.camel@jd-desktop.unknown.charter.com>
References: <4C2B97BE.7040405@nasa.gov>
	<BD69807DAE0CE44CA00A8338D0FDD08302E49509A9@oma00cexmbx03.corp.westworlds.com>
	<4C2BA2DF.2090900@nasa.gov>
	<1277928730.20538.2776.camel@jd-desktop.unknown.charter.com>

and what would be those "extremely specific purposes"?

Joshua D. Drake wrote:
> On Wed, 2010-06-30 at 16:02 -0400, Maria L. Wilson wrote:
>   
>> ok - thanks that makes sense....
>>
>> so what about the operating system account that is different?  What we 
>> are planning on doing with the OS acct (postgres) is only allowing users 
>> sudo ability to this account.  Nobody should be able to directly log 
>> into it.  Do you think that will cause problems?
>>     
>
> You should treat the postgres account like root. In reality nobody
> should be logging in as postgres on the OS except for extremely specific
> purposes.
>
> Joshua D. Drake
>
>   

view thread (12+ messages)  latest in thread

Message-ID: <4C2BA55D.9000700@nasa.gov>
Permalink:  ../4C2BA55D.9000700@nasa.gov/
Also on:    postgresql.org/message-id/4C2BA55D.9000700@nasa.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Maria.L.Wilson-1@nasa.gov, jd@commandprompt.com, m.l.wilson@nasa.gov, JRPlugge@west.com
  Subject: Re: postgres database user account
  In-Reply-To: <4C2BA55D.9000700@nasa.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox