"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> writes:
> 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?
No, that's pretty standard. RPM installations for example have never
assigned a password to the postgres OS account, so it will behave in
exactly that way.
Usually the only things you need the OS account for are to start/stop
the server and update its outside-the-database configuration files,
such as postgresql.conf.
regards, tom lane
