Re: Logging

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Andrew Bartley <ambartley(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Logging
Date: 2018-06-13 02:43:27
Message-ID: 1528857807.2657.3.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Bartley wrote:
> Can someone please tell me how to log the values being inserted in this example..
>
> 2018-06-12 22:31:49 UTC-5b2049d4.434ac-STATEMENT: insert into "api_consumers" ("consumer_id", "create_datetime") values ($1, $2).
>
> I have tried many different logging options and combinations.

That should automatically be logged as a DETAIL message.

log_min_duration_statement = 0
log_min_error_statement = log or better
log_min_messages = log or better

That should do the trick.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

  • Logging at 2018-06-12 22:37:14 from Andrew Bartley

Responses

  • Re: Logging at 2018-06-13 03:03:54 from Andrew Bartley

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Bartley 2018-06-13 03:03:54 Re: Logging
Previous Message a 2018-06-13 01:20:49 Re: Does pgAgent support chinese, japanese characters?