PostgreSQL

main website: http://www.postgresql.org

documentation: http://www.postgresql.org/docs/

shutting down

[rob@localhost ~]$ su 
Password: 
[root@localhost rob]# su - postgres 
[postgres@localhost ~]$ /usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -m smart 
waiting for server to shut down.... done server stopped 

user roles - creating, dropping, listing

• users can only access the database if they have been explicitly added to postgres. User can only be added by other users who have this right.
• v8.1.11 doc: http://www.postgresql.org/docs/8.1/static/user-manag.html
• create - after installation, you can create new roles while being the postgres user (after installation only the postgres user can do this). A typical createuser session might look like this:

  [postgres@localhost ~]$ /usr/local/pgsql/bin/createuser rob 
  Shall the new role be a superuser? (y/n) n 
  Shall the new role be allowed to create databases? (y/n) y 
  Shall the new role be allowed to create more new roles? (y/n) y 
  CREATE ROLE 
  [postgres@localhost ~]$

• drop - if you need to drop a user try this:

  /usr/local/pgsql/bin/dropuser username

• list - To determine the set of existing roles, examine the pg_roles system catalog, for example

  SELECT rolname FROM pg_roles;

log file

/home/postgres/logfile

* uses roles now, so to start up if you haven't set your username as a "role" try sudo -u postgres /usr/local/pgsql/bin/psql test

-- RobertSajan - 29 Apr 2008