Re: How do I create a Backup Operator account ? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: How do I create a Backup Operator account ?
Date
Msg-id CAKoxK+4xE=RoWT1e3Xug6U0vHegEGXbwEXFxrDRd5JvgaxssyQ@mail.gmail.com
Whole thread Raw
In response to Re: How do I create a Backup Operator account ?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: How do I create a Backup Operator account ?  (Marcos Aurelio Nobre <marconobre@gmail.com>)
List pgsql-general
On Tue, Jul 30, 2019 at 2:22 PM Ron <ronljohnsonjr@gmail.com> wrote:
> Luca, it is common some large Enterprise environments to have Operations
> staff that can run backups without being able to do anything else.  For
> example, SQL Server has a per-database user mapping named db_backupoperator.


Yes, but I think here we have to solve it with external tools, e.g.,
sudo. I see, however, an hard time configuring an account to execute
only pg_dump without being able to "escape" into the database itself.

Luca



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: How do I create a Backup Operator account ?
Next
From: Marcos Aurelio Nobre
Date:
Subject: Re: How do I create a Backup Operator account ?