MIME-Version: 1.0
From: Edwin UY <edwin.uy@gmail.com>
Date: Thu, 19 Dec 2024 12:01:48 +1300
Message-ID: 
 <CA+wokJ8dYUampK3_sxNg1RwCJ-cLWfqbSqALU4EJVt74eQr+8A@mail.gmail.com>
Subject: Logical replication - SELECT * FROM pg_logical_slot_get_changes
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002b9f27062993685d"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ8dYUampK3_sxNg1RwCJ-cLWfqbSqALU4EJVt74eQr%2B8A%40mail.gmail.com>
Precedence: bulk

--0000000000002b9f27062993685d
Content-Type: text/plain; charset="UTF-8"

Hi,

Just curious, what is the impact of running these and under  what scenario
would you necessarily run them?

SELECT * FROM pg_logical_slot_get_changes('fivetran_replication_slot',
NULL, NULL, 'stream-changes', '1');
SELECT * FROM pg_logical_slot_get_changes('fivetran_replication_slot',
NULL, NULL, 'include-xids', '0');

Can you actually run this to tell logical replication to start/reset
replicating from when?

Regards,
Ed

--0000000000002b9f27062993685d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Hi,</div><div><br></div><div>Just cu=
rious, what is the impact of running these and under=C2=A0 what scenario wo=
uld you necessarily run them?</div><div><br></div><div>SELECT * FROM pg_log=
ical_slot_get_changes(&#39;fivetran_replication_slot&#39;, NULL, NULL, &#39=
;stream-changes&#39;, &#39;1&#39;);<br>SELECT * FROM pg_logical_slot_get_ch=
anges(&#39;fivetran_replication_slot&#39;, NULL, NULL, &#39;include-xids=
9;, &#39;0&#39;);</div><div><br></div><div>Can you actually run this to tel=
l logical replication to start/reset replicating from when?<br></div><div><=
br></div><div>Regards,</div><div>Ed</div><div><br></div></div>
</div>

--0000000000002b9f27062993685d--