Re: How do I create a Backup Operator account ?

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How do I create a Backup Operator account ?
Date: 2019-07-30 13:22:07
Message-ID: CAKoxK+4xE=RoWT1e3Xug6U0vHegEGXbwEXFxrDRd5JvgaxssyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 30, 2019 at 2:22 PM Ron <ronljohnsonjr(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcos Aurelio Nobre 2019-07-31 00:47:57 Re: How do I create a Backup Operator account ?
Previous Message Ron 2019-07-30 12:21:51 Re: How do I create a Backup Operator account ?