"Bob Powell" <[EMAIL PROTECTED]> writes:
> My systems admin says that he needs to have use of the Postgres user
> without a password. His Debian package manager requires this.
> He tells me that he can lock down that user on the system so that there
> are no security concerns.
Why can't he put his password in ~/.pgpass?
Or if you don't like that, see if you can set up to let him in with
IDENT. But using TRUST on a multi-user machine is just asking for
trouble.
> Also, my method for creating another superuser is to update the
> pg_shadow files "usesuper" field to 't'.
The CREATEUSER option to CREATE/ALTER USER is the same thing.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
