Correction in doc of failover ready steps

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Correction in doc of failover ready steps
Date: 2024-07-22 05:16:53
Message-ID: CAJpy0uBBk+OZXXqQ00Gai09XR+mDi2=9sMBYY0F+BedoFivaMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

We have a query in failover-ready doc referring to
pg_subscription_rel. Unlike pg_subscription, pg_subscription_rel gives
results only when connected to the database having the
subscription(s). If we run the concerned query on any other database,
it will give incomplete results i.e. it will give info on main slots
leaving table sync slots (if any).
Thus the failover-ready steps which queries pg_subscription_rel need
to mention that the concerned query needs to be run on the database(s)
that includes the failover enabled subscription(s). Corrected the doc
for the same.

thanks
Shveta

Attachment Content-Type Size
v1-0001-Correction-in-doc-of-failover-ready-steps.patch application/octet-stream 1.8 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message shveta malik 2024-07-22 05:29:28 Re: Correction in doc of failover ready steps
Previous Message shveta malik 2024-07-22 05:15:14 Re: Fix an incorrect statement for failover option in alter_subscription.sgml