1
0

postgres.md 230 B

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.