Re: postgres database user account

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov
Cc: "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com>, "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS]" <m(dot)l(dot)wilson(at)nasa(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres database user account
Date: 2010-06-30 20:12:10
Message-ID: 1277928730.20538.2776.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maria L. Wilson 2010-06-30 20:13:17 Re: postgres database user account
Previous Message Plugge, Joe R. 2010-06-30 20:08:29 Re: postgres database user account