From: | Marcos Aurelio Nobre <marconobre(at)gmail(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How do I create a Backup Operator account ? |
Date: | 2019-07-31 00:47:57 |
Message-ID: | CALrcA6=Bmo5mXYAyavKe1aEmzLsaAaXLQXPLGW1Dwi0ODBPsUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've also been thinking about this possibility. Create a Linux (S.O.) user
account that has the ability to run pg_dump and pg_restore and enable this
user account to be able to connect to a database - I believe this is
possible through PG_HBA.CONF
But I don't know how to implement this on Linux, nor how to write this
entry in the pg_hba.conf file.
Em ter, 30 de jul de 2019 às 10:22, Luca Ferrari <fluca1978(at)gmail(dot)com>
escreveu:
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2019-07-31 05:48:36 | Re: How do I create a Backup Operator account ? |
Previous Message | Luca Ferrari | 2019-07-30 13:22:07 | Re: How do I create a Backup Operator account ? |