Re: Track in pg_replication_slots the reason why slots conflict?

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Track in pg_replication_slots the reason why slots conflict?
Date: 2024-01-01 11:53:58
Message-ID: CAJpy0uBEbkFtr+Atf1VdXQiC+rORgybp=Up7RXDqJcMkME09EA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jan 1, 2024 at 5:17 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> On Mon, Jan 1, 2024 at 4:30 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Mon, Jan 1, 2024 at 12:32 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
> > >
> > > PFA v3 after changing column name to 'conflict_reason'
> > >
> >
> > Few minor comments:
> > ===================
> > 1.
> > + <para>
> > + <literal>wal_removed</literal> = required WAL has been removed.
> > + </para>
> > + </listitem>
> > + <listitem>
> > + <para>
> > + <literal>rows_removed</literal> = required rows have been removed.
> > + </para>
> > + </listitem>
> > + <listitem>
> > + <para>
> > + <literal>wal_level_insufficient</literal> = wal_level
> > insufficient on the primary server.
> > + </para>
> >
> > Should we use the same style to write the description as we are using
> > for the wal_status column? For example, <literal>wal_removed</literal>
> > means that the required WAL has been removed.
> >
> > 2.
> > + <para>
> > + The reason of logical slot's conflict with recovery.
> >
> > My grammar tool says it should be: "The reason for the logical slot's
> > conflict with recovery."
> >
> > Other than these minor comments, the patch looks good to me.
>
> PFA v4 which addresses the doc comments.

Please ignore the previous patch and PFA new v4 (v4_2). The only
change from the earlier v4 is the subject correction in commit msg.

thanks
Shveta

Attachment Content-Type Size
v4_2-0001-Track-conflict_reason-in-pg_replication_slots.patch application/octet-stream 13.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2024-01-01 12:12:26 Re: add AVX2 support to simd.h
Previous Message shveta malik 2024-01-01 11:47:19 Re: Track in pg_replication_slots the reason why slots conflict?