PostgreSQL First Steps on Linux

pg_steps.md

1. sudo -u postgres psql template1
2. ALTER USER postgres with encrypted password 'xxxxxxx';
3. sudo subl /etc/postgresql/9.3/main/pg_hba.conf

#And change "peer" to "md5" on the line concerning postgres :
local      all     postgres     peer md5

4. sudo /etc/init.d/postgresql restart

5. Try

psql -U postgres