Обсуждение: Read only role for backup

I am using a new PostgreSQL 12 installation on a Linux box and would like to be able to back up the entire cluster as an ordinary user. 

I already have myself set up as an ordinary pg user with the same name as my Linux name, and I am using a .pgpass file for easy access.

I know I can, inside Postgres, grant myself select access on an object-by-object basis, but is there any simpler way to do it for the whole cluster?

Thanks.

-Tom

On Fri, Jan 24, 2020 at 06:32 Tom Browder <tom.browder@gmail.com> wrote:

...