Ubuntu PostgreSQL Setup

Ubuntu 12.04 install PostgreSQL 9.1 sudo apt-get update sudo apt-get install postgresql Login to use psql sudo -u postgres psql ALTER USER postgres WITH PASSWORD 'postgres'; create user sushi with password 'passwd'; SHOW config_file; \q \h create database rsyslog; create user rsyslog with password 'password'; grant all privileges on database "rsyslog" to rsyslog;