Log prefix missing for subscriber log messages received from publisher
vignesh C <vignesh21@gmail.com>
From: vignesh C <vignesh21@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-04-15T04:37:24Z
Lists: pgsql-hackers
Attachments
- register_notice_process.patch (application/octet-stream) patch
Hi, Currently, when a warning is emitted by the publisher, the corresponding log message does not include the log prefix. This makes it harder to correlate such messages with other log entries. For example, in a simulated error scenario where directory removal fails, the notice message lacks the standard log prefix, as shown below: 2025-03-18 16:44:36.071 IST [196901] LOG: logical replication table synchronization worker for subscription "sub1", table "t1" has finished WARNING: could not remove directory "pg_replslot/pg_16398_sync_16387_7483106341004194035.tmp" In this case, the WARNING line does not include the usual timestamp information, making it harder to trace. To address this, we can have a custom notice processor for WAL receiver connections—similar to what's done in the attached patch. This ensures that notices received during both streaming and logical replication include the appropriate log prefix. Since this issue is present in both replication modes, the patch sets the notice processor for all WAL receiver connections. Regards, Vignesh
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Remove translation marker from libpq-be-fe-helpers.h.
- a7ca73af662b 19 (unreleased) landed
-
Log remote NOTICE, WARNING, and similar messages using ereport().
- 112faf1378ee 19 (unreleased) landed
-
Remove translation markers from libpq-be-fe-helpers.h
- 213c959a294d 17.0 cited