Proper roles for a backup-only user on PostgreSQL
1
vote
1
answer
2011
views
I am working on new processes and policies for my PostgreSQL databases when they are first created, and I am trying to define what role attributes are necessary for a role specifically used for backups. I have found for MySQL that the grants
SELECT, PROCESS, LOCK TABLES, SHOW VIEW, TRIGGER
are enough for a user to perform backups, but I can't figure out how to translate grants like this to PostgreSQL.
Any recommendations, other than having to rely on Superuser
?
Asked by vPilot
(47 rep)
Feb 18, 2022, 03:37 PM
Last activity: Jan 17, 2025, 08:46 PM
Last activity: Jan 17, 2025, 08:46 PM