Re: postgres database user account

"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