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

Minimum privilege for Backup and replication

2019-10-10 Thread Timmy Siu
Dear All Postgresql Users, I am new to pgsql. I have an installation on my Ubuntu 18.04. Now, my question is - What is the Minimum Privilege of a pgsql Backup or Replication user? I know how to do it for mysql but not pgsql.?? I begin to switch to pgsql v11 from mysql v5.7 after knowing it many