Re: Truncate logs by max_log_size
Kirill Gavrilov <diphantxm@gmail.com>
From: Kirill Gavrilov <diphantxm@gmail.com>
To: Jim Jones <jim.jones@uni-muenster.de>
Cc: Kirill Reshke <reshkekirill@gmail.com>,
"Andrey M. Borodin" <x4mmm@yandex-team.ru>, Euler Taveira <euler@eulerto.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-01-31T10:46:37Z
Lists: pgsql-hackers
Attachments
- V6-0001-parameter-max_log_size-to-truncate-logs.patch (application/octet-stream) patch 0001
On Mon, Dec 2, 2024 at 1:09 PM Jim Jones <jim.jones@uni-muenster.de> wrote: > > > On 29.11.24 21:57, Kirill Gavrilov wrote: > > Same thing applies to log_parameter_max_length, for example. > > > > postgres=# set log_parameter_max_length = '1foo'; > > ERROR: invalid value for parameter "log_parameter_max_length": "1foo" > > HINT: Valid units for this parameter are "B", "kB", "MB", "GB", and > "TB". > > postgres=# set log_parameter_max_length = '1TB'; > > ERROR: invalid value for parameter "log_parameter_max_length": "1TB" > > HINT: Value exceeds integer range. > > > > I think we can leave it as is. > > I see. So I guess it is out of scope to change this message here. > > Small nitpicks: > > 1) The indentation of the comment at postgresql.conf.sample is a little > bit off > > #max_log_size = 0 # max size of logged statement > # 0 disables the feature > > IMHO it looks better like this: > > #max_log_size = 0 # max size of logged statement > # 0 disables the feature > > > 2) You introduced a trailing whitespace at L34 (Not critical :)) > > + Zero disables the setting. > > It happens to me all the time, so I usually try to apply my patches in a > clean branch just to make sure I didn't miss anything. > > Other than that, I have nothing more to add at this point. > > Thanks > > -- > Jim > > Sorry for the long silence. I fixed the indentation and a trailing whitespace. Should look fine now.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix log_statement_max_length test with verbose logs
- 9bfbf5bf6190 master landed
-
Add log_statement_max_length GUC to limit logged statement text
- c8bd8387c27a master landed
-
Improve user control over truncation of logged bind-parameter values.
- 0b34e7d307e6 13.0 cited