PostgreSQL

Installation

# apt-get install postgresql postgresql-client

Administration

Create role (user):

# su postgres
postgres $ createuser -l -d -R -S admin

Description of parameters:

• -l - login user (LOGIN)
• -d - can create databases (CREATEDB)
• -R - can not create roles
• -S - no superuser

Create database:

# su postgres
postgres $ createdb -O admin -E UTF8 -T template0 db1

Description of parameters:

• -O - owner of database
• -E - encoding
• -T - template

Sources:

• http://www.postgresql.org/docs/9.1/static/index.html