# Postgres SQL Tips for using Postgres SQL. ## Backup Create backup profile : ``` CREATE ROLE backup WITH NOSUPERUSER NOCREATEDB NOCREATEROLE ; ``` Use `\du` to list roles.