Databases Reference
In-Depth Information
3.
Create a new user, or "login role," as PostgreSQL calls it. Right-click on
Login
Roles
in the object browser (on the left) and select
New Login Role...
:
1.
Enter the username:
confluence
.
2.
Enter the password:
confluence
.
3.
Do not select any role privileges.
4.
Confirm the creation of the role.
4.
Create a new database; right-click on
Databases
and select
New Database
.
1.
Enter the database name:
confuencedb
.
2.
Set the owner of the database to the user we just created.
3.
Select
UTF-8
for encoding.
4.
Confirm the creation of the database.