test

Sun N1 Grid Engine 6.1 Installation Guide

ProcedureHow to Set Up a PostgreSQL Database

  1. Log in as the database superuser, for example, postgres.


    # su - postgres

  2. Create the owner of the database.


    > createuser -P arco_write
Enter password for new user: 
Enter it again: 
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER

  3. Create the database for accounting and reporting. 


    > createdb -O arco_write arco
CREATE DATABASE

  4. Create a database user for reading the database.

    If you do not use the arco_read user, you need to modify the privileges script that is used in the next step.


    > createuser -P arco_read
Enter password for new user: 
Enter it again: 
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER