Page Comparison

...

1. Server management
   
   1. sudo /etc/init.d/postgresql-8.3 stop
   2. sudo /etc/init.d/postgresql-8.3 start
   3. sudo /etc/init.d/postgresql-8.3 restart
2. Connect to a database
   
   1. psql -U postgres template1
3. Create user
   
   1. Login using postgres
   2. Run SQL: 
      
      1. create user [userid] WITH CREATEDB;
      2. GRANT USAGE ON LANGUAGE plpgsql TO tdar;
4. Create database
   
   1. Login with [userid]: psql -U [userid] template1
   2. Run SQL: create database [db1]