Postgres SQL

Tips for using Postgres SQL.

Use a database in a commandline

sudo service postgresql start ;
sudo -u postgres psql <db name> ;
sudo update-rc.d postgresql disable

Backup

Create backup profile :

CREATE ROLE backup WITH 
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE 
    LOGIN
    PASSWORD 'IWantToBackUp';

Use \du to list roles.