Skip to main content

FAQ

Add a User Account

  1. On the computer where PostgreSQL is installed, there should be an application called pgAdmin. (The icon looks like an elephant.)
  2. You'll want to open pgAdmin, there won't be much on the screen after it opens.
  3. On the left side of pgAdmin, you'll see Servers. Use the arrow to expand the list.
  4. After expanding the Servers list you should see PostgreSQL followed by the version number.
  5. Double-click on PostgreSQL to log in to the database. You may be prompted for a password. This should be the "master password" for postgres. (Hopefully this is saved somewhere accessible to you! This password was created when PostgreSQL was first installed.)
  6. After logging in, you'll want to expand the "Login/Group Roles" section. This will produce a list of all Users and Group Roles.
  7. Right click on Login/Group Roles and select Create then Login/Group Role
  8. In the Name field, enter the username you want to use.
  9. Click on Definition and enter a password in the password field.
  10. Click on Privileges, and turn on the following permissions:
    • Can login
    • Create databases
    • Inherit rights from parent roles
  11. Click on Membership then press the plus sign next to Member of, then use the dropdown to choose BdgtMstr. Repeat this process to add PyrlMstr.
  12. Finally click on Save.

Related articles