| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Mary Johnson <mary(dot)johnson1812(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: what to log in csvlogs |
| Date: | 2020-05-10 19:15:54 |
| Message-ID: | db0bdd96-39f7-9eb8-15f8-bfe0dfa38b52@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/10/20 11:27 AM, Mary Johnson wrote:
> Hi,
>
> Can you please let me know if we can control what to log when log
> destination is 'csvlog'?
No, it is set to the fields described here:
https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
What is in those fields is determined by the settings mentioned in the
link above.
> Also, can we control when to log to display only select queries of a few
> specific tables?
Not with the built in logger.
Other folks maybe able to point you at third party software that can do
this.
>
> Thanks,
> mary
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2020-05-10 19:17:21 | Re: Best way to use trigger to email a report ? |
| Previous Message | Mary Johnson | 2020-05-10 18:27:07 | what to log in csvlogs |