Stephen Frost wrote: > Even so, in the interest of having more fine-grained permission > controls, I've gone ahead and added a pg_switch_xlog default role. > Note that this means that pg_switch_xlog() can be called by both > pg_switch_xlog roles and pg_backup roles. I'd be very much against > removing the ability to call pg_switch_xlog from the pg_backup role as > that really is a capability which is needed by users running backups and > it'd just add unnecessary complexity to require users setting up backup > tools to grant two different roles to get the backup to work.
Isn't it simpler to grant pg_switch_xlog to pg_backup in the default config? -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers