From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Truncated queries in the pg_log file |
Date: | 2018-11-01 20:06:08 |
Message-ID: | d7843602-80c3-a2a7-6c6b-890dca7ef225@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
v8.4 (we're migrating to 9.6 tomorrow night, but the work must still
proceed today.)
SQL statements are being logged (which is good), but only the fist 400 or so
bytes is recorded. What knob do I tweak to record the whole query?
Here are the relevant postgres.conf items which are not commented out:
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%F.log'
log_rotation_age = 1d
silent_mode = off
client_min_messages = notice
log_min_messages = notice
log_min_error_statement = notice
log_min_duration_statement = 5000
log_checkpoints = on
log_line_prefix = '%m %d %r %u %p %x %i'
log_lock_waits = on
log_statement = 'mod'
log_temp_files = 1kB
track_activity_query_size = 10240
Thanks
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2018-11-01 20:23:18 | Add columns to table; insert values based on row |
Previous Message | James A. Robinson | 2018-11-01 18:05:03 | Re: Copy data from DB2 (Linux) to PG |