Installation of PostgreSQL can be done with a single click in the CWP GUI.

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
Tagged: