Re: Additional role attributes && superuser review

Поиск
Список
Период
Сортировка
От Adam Brightwell
Тема Re: Additional role attributes && superuser review
Дата
Msg-id CAKRt6CSk1O6sHukQA7CmMXc==8X9JpDpnCyds4hrSinqjm1L+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Additional role attributes && superuser review  (Robert Haas <robertmhaas@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,
 
>
> I'm slightly mystified as to how including the word "online" helps
> here.  It's unlikely that there will be an offline_backup permission,
> because if the system is off-line, SQL-level permissions are
> irrelevant.


After re-reading through this thread is seems like EXCLUSIVEBACKUP (proposed by Magnus) seemed to be a potentially acceptable alternative.

----
Relevant post: http://www.postgresql.org/message-id/CABUevEz7BZ0r85VUt4RVXX0JkpiH8hP8ToqzGVpuFL0KvcvBNg@mail.gmail.com
----
We need to separate the logical backups (pg_dump) from the physical ones
(start/stop+filesystem and pg_basebackup). We might also need to separate
the two different ways of doing physical backups.

Personalyl I think using the DUMP name makes that a lot more clear. Maybe
we need to avoid using BACKUP alone as well, to make sure it doesn't go the
other way - using BASEBACKUP and EXCLUSIVEBACKUP for those two different
ones perhaps?
----

----
Relevant post: http://www.postgresql.org/message-id/20141231144610.GS3062@tamriel.snowman.net
----
I think I'm coming around to the EXCLUSIVEBACKUP option, per the
discussion with Magnus.  I don't particularly like LOGBACKUP and don't
think it really makes sense, while PHYSBACKUP seems like it'd cover what
REPLICATION already does.
----

Thoughts?

-Adam

--
Adam Brightwell - adam.brightwell@crunchydatasolutions.com
Database Engineer - www.crunchydatasolutions.com

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Sawada Masahiko
Дата:
Сообщение: Re: Merging postgresql.conf and postgresql.auto.conf
Следующее
От: Arne Scheffer
Дата:
Сообщение: Re: Add min and max execute statement time in pg_stat_statement