Re: How do I create a Backup Operator account ?

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: How do I create a Backup Operator account ?
Дата
Msg-id CAKoxK+4xE=RoWT1e3Xug6U0vHegEGXbwEXFxrDRd5JvgaxssyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How do I create a Backup Operator account ?  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: How do I create a Backup Operator account ?  (Marcos Aurelio Nobre <marconobre@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: How do I create a Backup Operator account ?
Следующее
От: Marcos Aurelio Nobre
Дата:
Сообщение: Re: How do I create a Backup Operator account ?