Logical replication - SELECT * FROM pg_logical_slot_get_changes

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Logical replication - SELECT * FROM pg_logical_slot_get_changes
Date: 2024-12-18 23:01:48
Message-ID: CA+wokJ8dYUampK3_sxNg1RwCJ-cLWfqbSqALU4EJVt74eQr+8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2024-12-19 22:49:13 General Enquiry
Previous Message shammat 2024-12-18 18:32:22 Re: Seeking Recommendations for Oracle to PostgreSQL Synchronization Tools