Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2772]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2772', MSGID: '-', TIMESTAMP: 'Dec 9 05:11:05', STRUCTURED-DATA: '[DATABASE]', msg: '[308-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:05.015 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="302" LOG: restored log file "0000000100000332000000BF" from archive' escaped msg: '[308-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:05.015 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="302" LOG: restored log file "0000000100000332000000BF" from archive' inputname: drain rawmsg: '<134>1 2025-12-09T05:11:05+00:00 host app postgres.2772 - [DATABASE] [308-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:05.015 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="302" LOG: restored log file "0000000100000332000000BF" from archive' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-test-ore-01-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "319", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "logplex-frame-id": "fe5edb7d-cfda-4dd3-8d13-02587216fe61", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (878c4b46ede4)", "x-forwarded-for": "44.235.124.40", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "da3112ec-ffff-8568-a0cc-1f73cf8b386e", "x-request-start": "1765257065790" }, "queryparams": { "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[308-1] sql_error_code = 00000 time_ms = \"2025-12-09 05:11:05.015 UTC\" pid=\"8\" proc_start_time=\"2025-11-07 20:35:00 UTC\" session_id=\"690e57f4.8\" vtid=\"556\/0\" tid=\"0\" log_line=\"302\" LOG: restored log file \"0000000100000332000000BF\" from archive", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "agent_timestamp": "2025-12-09T05:11:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "severity": "info", "uuid": "13c4fc91-72bc-4964-b9c4-091a9365ab43" }, "owner": { "service": "lmp", "team": "lmp", "environment": "testing", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "source": "app", "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "testing", "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.2772]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2772', MSGID: '-', TIMESTAMP: 'Dec 9 05:11:07', STRUCTURED-DATA: '[DATABASE]', msg: '[309-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:07.775 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="303" LOG: restored log file "0000000100000332000000C0" from archive' escaped msg: '[309-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:07.775 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="303" LOG: restored log file "0000000100000332000000C0" from archive' inputname: drain rawmsg: '<134>1 2025-12-09T05:11:07+00:00 host app postgres.2772 - [DATABASE] [309-1] sql_error_code = 00000 time_ms = "2025-12-09 05:11:07.775 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="303" LOG: restored log file "0000000100000332000000C0" from archive' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-test-ore-01-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "319", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "logplex-frame-id": "996fe211-de00-4225-9c16-4ca0be10757a", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (878c4b46ede4)", "x-forwarded-for": "52.13.91.185", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a495b076-d363-e6c5-e7ee-31e2250d83a3", "x-request-start": "1765257068137" }, "queryparams": { "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[309-1] sql_error_code = 00000 time_ms = \"2025-12-09 05:11:07.775 UTC\" pid=\"8\" proc_start_time=\"2025-11-07 20:35:00 UTC\" session_id=\"690e57f4.8\" vtid=\"556\/0\" tid=\"0\" log_line=\"303\" LOG: restored log file \"0000000100000332000000C0\" from archive", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "agent_timestamp": "2025-12-09T05:11:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "severity": "info", "uuid": "13c4fc91-72bc-4964-b9c4-091a9365ab43" }, "owner": { "service": "lmp", "team": "lmp", "environment": "testing", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "source": "app", "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "testing", "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.2772]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2772', MSGID: '-', TIMESTAMP: 'Dec 9 05:22:07', STRUCTURED-DATA: '[DATABASE]', msg: '[312-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:07.767 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="306" LOG: restored log file "0000000100000332000000C1" from archive' escaped msg: '[312-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:07.767 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="306" LOG: restored log file "0000000100000332000000C1" from archive' inputname: drain rawmsg: '<134>1 2025-12-09T05:22:07+00:00 host app postgres.2772 - [DATABASE] [312-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:07.767 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="306" LOG: restored log file "0000000100000332000000C1" from archive' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-test-ore-01-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "319", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "logplex-frame-id": "b50eff84-1eab-447f-bc9a-95e2abd2aed2", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (878c4b46ede4)", "x-forwarded-for": "52.13.91.185", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "3774cb69-e950-6da1-caae-8d9bec38ecd2", "x-request-start": "1765257728166" }, "queryparams": { "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[312-1] sql_error_code = 00000 time_ms = \"2025-12-09 05:22:07.767 UTC\" pid=\"8\" proc_start_time=\"2025-11-07 20:35:00 UTC\" session_id=\"690e57f4.8\" vtid=\"556\/0\" tid=\"0\" log_line=\"306\" LOG: restored log file \"0000000100000332000000C1\" from archive", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "agent_timestamp": "2025-12-09T05:22:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "severity": "info", "uuid": "13c4fc91-72bc-4964-b9c4-091a9365ab43" }, "owner": { "service": "lmp", "team": "lmp", "environment": "testing", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "source": "app", "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "testing", "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.2772]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2772', MSGID: '-', TIMESTAMP: 'Dec 9 05:22:09', STRUCTURED-DATA: '[DATABASE]', msg: '[314-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:09.963 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="308" LOG: unexpected pageaddr 332/82000000 in WAL segment 0000000100000332000000C2, LSN 332/C2000000, offset 0' escaped msg: '[314-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:09.963 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="308" LOG: unexpected pageaddr 332/82000000 in WAL segment 0000000100000332000000C2, LSN 332/C2000000, offset 0' inputname: drain rawmsg: '<134>1 2025-12-09T05:22:09+00:00 host app postgres.2772 - [DATABASE] [314-1] sql_error_code = 00000 time_ms = "2025-12-09 05:22:09.963 UTC" pid="8" proc_start_time="2025-11-07 20:35:00 UTC" session_id="690e57f4.8" vtid="556/0" tid="0" log_line="308" LOG: unexpected pageaddr 332/82000000 in WAL segment 0000000100000332000000C2, LSN 332/C2000000, offset 0' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-test-ore-01-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "362", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "logplex-frame-id": "d0bed628-a771-4fca-a015-5c9eafc3b9ac", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (878c4b46ede4)", "x-forwarded-for": "44.235.124.40", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eb9c5c7e-c5b3-8706-7e6c-d678e1253064", "x-request-start": "1765257730738" }, "queryparams": { "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[314-1] sql_error_code = 00000 time_ms = \"2025-12-09 05:22:09.963 UTC\" pid=\"8\" proc_start_time=\"2025-11-07 20:35:00 UTC\" session_id=\"690e57f4.8\" vtid=\"556\/0\" tid=\"0\" log_line=\"308\" LOG: unexpected pageaddr 332\/82000000 in WAL segment 0000000100000332000000C2, LSN 332\/C2000000, offset 0", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "agent_timestamp": "2025-12-09T05:22:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "severity": "info", "uuid": "13c4fc91-72bc-4964-b9c4-091a9365ab43" }, "owner": { "service": "lmp", "team": "lmp", "environment": "testing", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.4da8235a-2477-481a-9acd-1c4a38ee9e30", "source": "app", "dyno": "postgres.2772", "app": "sfdc-lm-test-ore-01-sh-admin", "space": "sfdc-lm-test-ore", "region": "oregon", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "testing", "cloud": "digitalengagement", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: