Table of Contents
Postgresql User Management
Changing a user password
su -c psql postgres
\password tdobes
Creating a user
su -c "createuser -d -P -r -s tdobes" postgres
-d
= can create databases-P
= prompt for password-r
= can create new roles (a.k.a. users or groups)-s
= is superuser
su -c "createuser -P drupal" postgres
Creating a database
su -c "createdb --encoding=UNICODE --owner=drupal --template=template0 drupaldb" postgres