Re: Loggingt psql meta-commands

Поиск
Список
Период
Сортировка
От oleg yusim
Тема Re: Loggingt psql meta-commands
Дата
Msg-id CAKd4e_HpQuEUX_tNaWvEZsYti67u6YnggdJ0ruiRM5+jzDW=9Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Loggingt psql meta-commands  (Andreas Kretschmer <akretschmer@spamfence.net>)
Ответы Re: Loggingt psql meta-commands  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Loggingt psql meta-commands  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Andreas, Andrian,

Thank you very much for both pieces of information. It was very helpful. Now, let me ask you one more question on the same topic. Is it more granular way to control logging PosgreSQL provides, or I pretty much reduced to choosing between mod and all? 

The reason I'm asking is because with 'all" volume of daily logging becomes truly ginormous. And for my purposes, I really do not need all the SELECT statements to be logged. Only those, which are responsible for explicit querying of role/privileges/roles (so, \du, \dp, \z, in essence).

Thanks,

Oleg

On Thu, Dec 10, 2015 at 12:14 PM, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
oleg yusim <olegyusim@gmail.com> wrote:

> Greetings!
>
> I'm new to PostgreSQL, working on it from the point of view of Cyber Security
> assessment. In regards to the here is my question:
>
> Is it a way to enable logging for psql prompt meta-commands, such as \du, \dp,
> \z, etc?

start psql with -E


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Loggingt psql meta-commands
Следующее
От: oleg yusim
Дата:
Сообщение: Re: Loggingt psql meta-commands