Re: Reducing the log spam - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Reducing the log spam
Date
Msg-id cf374c4a52d2c93cdc118f4245feb6cc822a34f8.camel@cybertec.at
Whole thread Raw
In response to Re: Reducing the log spam  (Jelte Fennema-Nio <postgres@jeltef.nl>)
Responses Re: Reducing the log spam
Re: Reducing the log spam
List pgsql-hackers
On Mon, 2024-03-11 at 09:33 +0100, Jelte Fennema-Nio wrote:
> -   the subscriber's server log.
> +   the subscriber's server log if you remove <literal>23505</literal> from
> +   <xref linkend="guc-log-suppress-errcodes"/>.
>
> This seems like a pretty big regression. Being able to know why your
> replication got closed seems pretty critical.

Yes.  But I'd argue that that is a shortcoming of logical replication:
there should be a ways to get this information via SQL.  Having to look into
the log file is not a very useful option.

The feature will become much less useful if unique voilations keep getting logged.

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Removing unneeded self joins
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: Reducing the log spam