- On the computer where PostgreSQL is installed, there should be an application called pgAdmin. (The icon looks like an elephant.)
- You'll want to open pgAdmin, there won't be much on the screen after it opens.
- On the left side of pgAdmin, you'll see Servers. Use the arrow to expand the list.
- After expanding the Servers list you should see PostgreSQL followed by the version number.
- 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.)
- After logging in, you'll want to expand the "Login/Group Roles" section. This will produce a list of all Users and Group Roles.
- Right click on Login/Group Roles and select Create then Login/Group Role
- In the Name field, enter the username you want to use.
- Click on Definition and enter a password in the password field.
- Click on Privileges, and turn on the following permissions:
- Can login
- Create databases
- Inherit rights from parent roles
- 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.
- Finally click on Save.
FAQ