This is now covered by the
pgluser and account management documentation.
All users have a standard PostgreSQL 'role'. This allows both Kerberos and MD5 password access, depending on whether SSL is enabled or not.
psql -h pgteach [optional db name]will invoke this.
Check that the user does not already have an account!
# returns "1" or "0" to confirm presence or absence of account... [pgxxxx]postgres$ psql -t -c "SELECT count(rolname) FROM pg_roles WHERE rolname = '<username>';"
If the user is entitled, please follow the account management documentation.
See the above procedure for the simplest way to reset a password.
This SQL allows a user to reset their own password whether or not the original password is known. Direct user to perform the following:
> ALTER ROLE username WITH password 'new password here';
End-of-session account cleanup
To be completed
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh