Re: How to watch for schema changes

On 07/12/2018 06:19 PM, Igor Korot wrote:
> Hi,
>
>
> On Thu, Jul 12, 2018 at 7:45 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

>
>> Can you try that again as root? Or with sudo?
>
> Yes, it did show up.
> But now it looks like I have 2 places to set the logging:
>
> log_statement_stats which I presume is just for statistics and
> log_statement which I presume I should change.

All is answered here:

https://www.postgresql.org/docs/10/static/runtime-config-logging.html

>
> Am I right?
> Also, I had to turn on logging - use csvlog, and enable the directory
> and filename.
> I presume that this will not require the restart of the server, correct?
>
> Thank you.
>
>>
>>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com