Re: replication commands and log_statements

Поиск
Список
Период
Сортировка
Искать
От
Stephen Frost
Тема
Re: replication commands and log_statements
Дата
Msg-id
20140814134903.GM16422@tamriel.snowman.net
Ответ на
Список
Дерево обсуждения
replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Andres Freund <andres@2ndquadrant.com>
Re: replication commands and log_statements Magnus Hagander <magnus@hagander.net>
Re: replication commands and log_statements Andres Freund <andres@2ndquadrant.com>
Re: replication commands and log_statements Magnus Hagander <magnus@hagander.net>
Re: replication commands and log_statements Andres Freund <andres@2ndquadrant.com>
Re: replication commands and log_statements Magnus Hagander <magnus@hagander.net>
Re: replication commands and log_statements Andres Freund <andres@2ndquadrant.com>
Re: replication commands and log_statements Tom Lane <tgl@sss.pgh.pa.us>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Ian Barwick <ian@2ndquadrant.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Heikki Linnakangas <hlinnakangas@vmware.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Tom Lane <tgl@sss.pgh.pa.us>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Stephen Frost <sfrost@snowman.net>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Bruce Momjian <bruce@momjian.us>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Stephen Frost <sfrost@snowman.net>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Amit Kapila <amit.kapila16@gmail.com>
Re: replication commands and log_statements Bruce Momjian <bruce@momjian.us>
Re: replication commands and log_statements Stephen Frost <sfrost@snowman.net>
Re: replication commands and log_statements Amit Kapila <amit.kapila16@gmail.com>
Re: replication commands and log_statements Stephen Frost <sfrost@snowman.net>
Re: replication commands and log_statements Amit Kapila <amit.kapila16@gmail.com>
Re: replication commands and log_statements Stephen Frost <sfrost@snowman.net>
Re: replication commands and log_statements Amit Kapila <amit.kapila16@gmail.com>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Michael Paquier <michael.paquier@gmail.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Robert Haas <robertmhaas@gmail.com>
Re: replication commands and log_statements Fujii Masao <masao.fujii@gmail.com>
Re: replication commands and log_statements Michael Paquier <michael.paquier@gmail.com>
Re: replication commands and log_statements Michael Paquier <michael.paquier@gmail.com>
Amit,

* Amit Kapila (amit.kapila16@gmail.com) wrote:
> On Thu, Aug 14, 2014 at 5:56 AM, Stephen Frost  wrote:
> > Regarding this, I'm generally in the camp that says to just include it
> > in 'all' and be done with it- for now.
> 
> Okay, but tomorrow if someone wants to implement a patch to log
> statements executed through SPI (statements inside functions), then
> what will be your suggestion, does those also can be allowed to log
> with 'all' option or you would like to suggest him to wait for a proper
> auditing system?

No, I'd suggest having a different option for it as that would be a huge
change for people who are already doing 'all', potentially.  Adding the
replication commands is extremely unlikely to cause individuals who are
already logging 'all' any problems, as far as I can tell.

> Wouldn't allowing to log everything under 'all' option can start
> confusing some users without having individual
> (ddl, mod, replication, ...) options for different kind of statements.

I don't see logging replication commands under 'all' as confusing, no.
Thanks,
	Stephen
В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Tom Lane
Дата:
FAQ