# Permissions for pg dump

Required permissions for a database backup with pg_dump

GRANT CONNECT ON DATABASE <db name> to <backup user>;
\c <db name>
GRANT SELECT ON ALL TABLES IN SCHEMA public to <backup user>;
GRANT SELECT, USAGE ON ALL SEQUENCES IN SCHEMA public TO <backup user>;