JovianLinux/Guides/postgres.md

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.