479
edits
Changes
Jump to navigation
Jump to search
Database Server Documentation (view source)
Revision as of 16:52, 30 October 2017
, 16:52, 30 October 2017no edit summary
When the box was built, we created an account called '''mcnair'''. This account isn't in the sudoers file but can sudo su itself. The password on this account was changed on 13th May 2016 to the new admin password. The root account has no password.
==Editing Users==
NOTE: The Postgres .conf files are in:
/etc/postgresql/9.5/main
To add a user to the database from the shell:
createuser username
To delete a user from the database from the shell:
dropuser username
From the server, you can list the users of the database using:
\du
To update the password for any of these users, from the database use:
\password username
There is a superuser named postgres that has access to the server and the box. If you need a user/password combo for a script that needs access to both, you'll need these credentials.
username: postgres
password: ask Anne (This is not the password)
NOTE: To get this combination to work, we had to change a line in
/etc/postgresql/9.5/main/pg_hba.conf
The line was changed from
local all postgres peer
to
local all postgres md5
[[admin_classification::IT Build| ]]
