Re: pgsql: Log remote NOTICE, WARNING, and similar messages using ereport()

From: Andrei Lepikhov <lepihov(at)gmail(dot)com>
To: Fujii Masao <fujii(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Log remote NOTICE, WARNING, and similar messages using ereport()
Date: 2025-07-22 12:30:48
Message-ID: 39ac724e-58c8-4661-9e88-cb4ee97cb00e@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 22/7/2025 07:22, Fujii Masao wrote:
> Log remote NOTICE, WARNING, and similar messages using ereport().
>
> Previously, NOTICE, WARNING, and similar messages received from remote
> servers over replication, postgres_fdw, or dblink connections were printed
> directly to stderr on the local server (e.g., the subscriber). As a result,
> these messages lacked log prefixes (e.g., timestamp), making them harder
> to trace and correlate with other log entries.
>
> This commit addresses the issue by introducing a custom notice receiver
> for replication, postgres_fdw, and dblink connections. These messages
> are now logged via ereport(), ensuring they appear in the logs with proper
> formatting and context, which improves clarity and aids in debugging.
Perhaps I'm wrong, but it seems to me that you also need to add the
libintl link to the Makefile of each module that uses the
libpqsrv_notice_receiver routine.
At least, without this patch, I can't build master under MacOS:

Undefined symbols for architecture x86_64:
"_libintl_gettext", referenced from:
_libpqsrv_notice_receiver in dblink.o
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see
invocation)

--
regards, Andrei Lepikhov

Attachment Content-Type Size
v0-0001-Fix-Makefile-in-modules-employing-the-libpqsrv_no.patch text/plain 1.2 KB

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Álvaro Herrera 2025-07-22 12:51:46 Re: pgsql: Log remote NOTICE, WARNING, and similar messages using ereport()
Previous Message Bertrand Drouvot 2025-07-22 07:01:09 Re: pgsql: Introduce pg_shmem_allocations_numa view

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2025-07-22 12:45:42 Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Previous Message Vik Fearing 2025-07-22 12:26:25 Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions