# Postgres SQL

Tips for using Postgres SQL.

## Backup

Create backup profile :

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

Use `\du` to list roles.