postgres setup on the linode

postgres-setup.sh

sudo su postgres
psql

postgres=# create role askbot with createdb login encrypted password 'askbot';

#     --> CREATE ROLE

postgres=# create database askbot with owner=askbot;

     --> CREATE DATABASE



# the pg_hba.conf is located at

/etc/postgresql/9.1/main/pg_hba.conf



# add row as stated in askbot docs

# values according above

local     askbot     askbot     md5 



# (re)start postgres server

/etc/init.d/postgresql restart