Installation of PostgreSQL can be done with a single click in the CWP GUI.
Video instructions
PostgreSQL Usage (command line)
Login to postgresql prompt
su - postgres psql
set postgres password
postgres=# \password postgres Enter new password: Enter it again: postgres=# \q
To install PostgreSQL Adminpack, enter the command in postgresql prompt
postgres=# CREATE EXTENSION adminpack CREATE EXTENSION
Create User and Database
postgres=# createuser USERNAME postgres=# createdb DATABASENAME
Set User Password
postgres=# alter user USERNAME with encrypted password 'NEW-PASSWORD' ALTER ROLE
Add Privileges on database to User
postgres=# grant all privileges on database DATABASENAME to USERNAME GRANT
Delete Database
postgres=# dropdb DATABASENAME
Delete User
postgres=# dropuser USERNAME