Re: Additional role attributes && superuser review

Поиск

Список

Период

Сортировка

От	Adam Brightwell
Тема	Re: Additional role attributes && superuser review
Дата	16 января 2015 г. 02:03:37
Msg-id	CAKRt6CSx=HOB0XovCfR4VBeh=hoa_AabAfMYNGAYrzUy1ghujg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Additional role attributes && superuser review (Stephen Frost <sfrost@snowman.net>)
Ответы	Re: Additional role attributes && superuser review (Robert Haas <robertmhaas@gmail.com>)
Список	pgsql-hackers

Дерево обсуждения

All,

Attached is a patch that proposes the following additional role attributes for review:

* ONLINE_BACKUP - allows role to perform backup operations

- originally proposed as BACKUP - due to concern for the use of that term in relation to other potential backup related permissions this form is in line with the documentation as it describes the affected backup operations as being 'online backups'.

- applies only to the originally proposed backup functions.

* XLOG_REPLAY - allows role to perform pause and resume on xlog_replay operations ('pg_xlog_replay_pause' and 'pg_xlog_replay_resume')

- following the recommendation from Stephen and Magnus.

* LOG - allows role to rotate log files - remains broad enough to consider future log related operations

* MONITOR - allows role to view pg_stat_* details (as originally proposed)

* SIGNAL - allows role to signal backend processes (as originally proposed)

The documentation still needs to be updated. If this these attributes and the capabilities they provide are acceptable, then I'll begin moving forward on making those updates as well.

Regarding the discussion on a DUMP/READONLY permission. I believe that topic needs much further discussion and decided it is probably best to keep it as a separate patch/effort. I'd certainly be willing to continue that discussion and assist in moving any related effort forward, therefore, please let me know if there is anything I can do to help.

Thanks,

Adam

Adam Brightwell - adam.brightwell@crunchydatasolutions.com

Database Engineer - www.crunchydatasolutions.com