Postgres Pro
Downloads
Home   >   mailing lists

Logical replication - SELECT * FROM pg_logical_slot_get_changes - Mailing list pgsql-admin

From Edwin UY
Subject Logical replication - SELECT * FROM pg_logical_slot_get_changes
Date
Msg-id CA+wokJ8dYUampK3_sxNg1RwCJ-cLWfqbSqALU4EJVt74eQr+8A@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Seeking Recommendations for Oracle to PostgreSQL Synchronization Tools
Next
From: Edwin UY
Date:
Subject: General Enquiry