I'm trying to automate the creation of a user for database backup on Postgresql. What grants are required to run pg_dump?
You need CONNECT on the database in question, USAGE on all schemas and SELECT on all tables, views and sequences.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
4 years ago