Sample Header Ad - 728x90

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