log statements span multiple lines
От | Stuart Kendrick |
---|---|
Тема | log statements span multiple lines |
Дата | |
Msg-id | 4CF26AE7.9060206@fhcrc.org обсуждение исходный текст |
Ответы |
Re: log statements span multiple lines
|
Список | pgsql-novice |
How do I tell postmaster to log SQL statements to a single line? At the moment, a particular statement gets chopped up across multiple syslog lines: Nov 28 06:28:31 guru postgres[5698]: [4-1] LOG: 00000: statement: SELECT mac, ip_addr, vlan, ad_ou, os_hostname, dns_hostname, Nov 28 06:28:31 guru postgres[5698]: [4-2] version_name, snmp_sys_descr, snmp_sys_objectid, wireless_ap, Nov 28 06:28:31 guru postgres[5698]: [4-3] switch_name, slot, port, first_seen, last_seen, last_updated FROM hosts LEFT JOIN switch_ports ON Nov 28 06:28:31 guru postgres[5698]: [4-4] hosts.switch_port = switch_ports.portid LEFT JOIN switches ON switch_ports.switch = switches.switchid LEFT JOIN os_versions ON Nov 28 06:28:31 guru postgres[5698]: [4-5] hosts.osver = os_versions.versionid WHERE ip_addr = '10.1.2.3' ORDER BY ip_addr ASC whereas I would prefer to see: Nov 28 06:28:31 guru postgres[5698]: [4-1] LOG: 00000: statement: SELECT mac, ip_addr, vlan, ad_ou, os_hostname, dns_hostname, version_name, snmp_sys_descr, snmp_sys_objectid, wireless_ap, switch_name, slot, port, first_seen, last_seen, last_updated FROM hosts LEFT JOIN switch_ports ON hosts.switch_port = switch_ports.portid LEFT JOIN switches ON switch_ports.switch = switches.switchid LEFT JOIN os_versions ON hosts.osver = os_versions.versionid WHERE ad_ou IS NOT NULL ORDER BY ip_addr ASC Nov 28 06:28:32 guru {some other log message} --sk Stuart Kendrick FHCRC
В списке pgsql-novice по дате отправления: