Read only role for backup - Mailing list pgsql-novice

From Tom Browder
Subject Read only role for backup
Date
Msg-id CAFMGiz8kM80xTxYhj7sHHLuuzu2MqTp7RZrqruDj1S3Ue9Rziw@mail.gmail.com
Whole thread Raw
Responses Re: Read only role for backup  (Tom Browder <tom.browder@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Keith Fiske
Date:
Subject: Re: postgresql rookie needs help with system catalog
Next
From: Tom Browder
Date:
Subject: Re: Read only role for backup