Re: Logging - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Logging
Date
Msg-id 1528857807.2657.3.camel@cybertec.at
Whole thread Raw
In response to Logging  (Andrew Bartley <ambartley@gmail.com>)
Responses Re: Logging  (Andrew Bartley <ambartley@gmail.com>)
List 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


pgsql-general by date:

Previous
From: "a"
Date:
Subject: Re: Does pgAgent support chinese, japanese characters?
Next
From: Andrew Bartley
Date:
Subject: Re: Logging