Re: Minimum privilege for Backup and replication

2019-10-10 Thread Stephen Frost
Greetings, * Timmy Siu (timmy@aol.com) wrote: > Now, my question is - > What is the Minimum Privilege of a pgsql Backup or Replication user? To perform a file-level backup of PostgreSQL, your OS user will need read access to all of the files in the data directory (you can use group privileges

Re: Minimum privilege for Backup and replication

2019-10-10 Thread Luca Ferrari
On Thu, Oct 10, 2019 at 1:26 PM Timmy Siu wrote: > Now, my question is - > What is the Minimum Privilege of a pgsql Backup or Replication user? It is not clear what your question really is. If you are thinking about a "database user with backup grant", there is no thing like that in PostgreSQL. I