Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 133, syslogtag 'app[postgres.1987795]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.1987795', MSGID: '-', TIMESTAMP: 'Mar 14 05:06:07', STRUCTURED-DATA: '[MAUVE]', msg: '[12-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.576 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/37959" tid="0" log_line="4" database="postgres" connection_source="[local]" user="postgres" application_name="psql" NOTICE: all required WAL segments have been archived' escaped msg: '[12-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.576 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/37959" tid="0" log_line="4" database="postgres" connection_source="[local]" user="postgres" application_name="psql" NOTICE: all required WAL segments have been archived' inputname: drain rawmsg: '<133>1 2025-03-14T05:06:07+00:00 host app postgres.1987795 - [MAUVE] [12-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.576 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/37959" tid="0" log_line="4" database="postgres" connection_source="[local]" user="postgres" application_name="psql" NOTICE: all required WAL segments have been archived' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-gs0-vir-00-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "965", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8563343d-8b15-4330-93a3-85e648f72a67", "logplex-frame-id": "06f82045-38b5-4d90-b101-45432ccef029", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "3.229.31.35", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6c22336f-68cb-f0ee-d909-ead4bb0b368b", "x-request-start": "1741928768386" }, "queryparams": { "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[12-1] sql_error_code = 00000 time_ms = \"2025-03-14 05:06:07.576 UTC\" pid=\"181121\" proc_start_time=\"2025-03-14 05:06:05 UTC\" session_id=\"67d3b93d.2c381\" vtid=\"24\/37959\" tid=\"0\" log_line=\"4\" database=\"postgres\" connection_source=\"[local]\" user=\"postgres\" application_name=\"psql\" NOTICE: all required WAL segments have been archived", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.8563343d-8b15-4330-93a3-85e648f72a67", "agent_timestamp": "2025-03-14T05:06:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.1987795", "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "severity": "notice", "uuid": "801de98f-6e38-431a-83fb-5319070909f5" }, "owner": { "service": "lmp", "team": "lmp", "environment": "gs0", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.8563343d-8b15-4330-93a3-85e648f72a67", "source": "app", "dyno": "postgres.1987795", "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "gs0", "cloud": "digitalengagement", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.1987795]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.1987795', MSGID: '-', TIMESTAMP: 'Mar 14 05:06:07', STRUCTURED-DATA: '[MAUVE]', msg: '[13-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.577 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/0" tid="0" log_line="5" database="postgres" connection_source="[local]" user="postgres" application_name="psql" LOG: duration: 2040.595 ms statement: COPY (SELECT file_name, lpad(file_offset::text, 8, '0') AS file_offset FROM pg_walfile_name_offset( (SELECT lsn FROM pg_stop_backup(true)))) TO STDOUT WITH CSV HEADER;' escaped msg: '[13-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.577 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/0" tid="0" log_line="5" database="postgres" connection_source="[local]" user="postgres" application_name="psql" LOG: duration: 2040.595 ms statement: COPY (SELECT file_name, lpad(file_offset::text, 8, '0') AS file_offset FROM pg_walfile_name_offset( (SELECT lsn FROM pg_stop_backup(true)))) TO STDOUT WITH CSV HEADER;' inputname: drain rawmsg: '<134>1 2025-03-14T05:06:07+00:00 host app postgres.1987795 - [MAUVE] [13-1] sql_error_code = 00000 time_ms = "2025-03-14 05:06:07.577 UTC" pid="181121" proc_start_time="2025-03-14 05:06:05 UTC" session_id="67d3b93d.2c381" vtid="24/0" tid="0" log_line="5" database="postgres" connection_source="[local]" user="postgres" application_name="psql" LOG: duration: 2040.595 ms statement: COPY (SELECT file_name, lpad(file_offset::text, 8, '0') AS file_offset FROM pg_walfile_name_offset( (SELECT lsn FROM pg_stop_backup(true)))) TO STDOUT WITH CSV HEADER;' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-gs0-vir-00-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "965", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8563343d-8b15-4330-93a3-85e648f72a67", "logplex-frame-id": "06f82045-38b5-4d90-b101-45432ccef029", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "3.229.31.35", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6c22336f-68cb-f0ee-d909-ead4bb0b368b", "x-request-start": "1741928768386" }, "queryparams": { "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[13-1] sql_error_code = 00000 time_ms = \"2025-03-14 05:06:07.577 UTC\" pid=\"181121\" proc_start_time=\"2025-03-14 05:06:05 UTC\" session_id=\"67d3b93d.2c381\" vtid=\"24\/0\" tid=\"0\" log_line=\"5\" database=\"postgres\" connection_source=\"[local]\" user=\"postgres\" application_name=\"psql\" LOG: duration: 2040.595 ms statement: COPY (SELECT file_name, lpad(file_offset::text, 8, '0') AS file_offset FROM pg_walfile_name_offset( (SELECT lsn FROM pg_stop_backup(true)))) TO STDOUT WITH CSV HEADER;", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.8563343d-8b15-4330-93a3-85e648f72a67", "agent_timestamp": "2025-03-14T05:06:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.1987795", "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "severity": "info", "uuid": "801de98f-6e38-431a-83fb-5319070909f5" }, "owner": { "service": "lmp", "team": "lmp", "environment": "gs0", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.8563343d-8b15-4330-93a3-85e648f72a67", "source": "app", "dyno": "postgres.1987795", "app": "sfdc-lm-gs0-vir-00-sh-admin", "space": "sfdc-lm-gs0-vir", "region": "virginia", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "gs0", "cloud": "digitalengagement", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: