Synchronize the dump with a logical slot with --snapshot

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org
Subject: Synchronize the dump with a logical slot with --snapshot
Date: 2024-09-19 19:57:56
Message-ID: CAJCZkoJ_=jAf+HVh8_fGRw-C+HAD7M0k+HKD=4Bvc1KcbZVnfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-in-general

Hi Team

--snapshot=*snapshotname*

(Use the specified synchronized snapshot when making a dump of the database

This option is useful when needing to synchronize the dump with a logical
replication slot) as per the pgdg

How do we synchronize the dump with a logical replication slot
with --snapshot?

I am using the postgresql 14 version which supports only
pg_create_logical_replication_slot. How to generate a snapshot with it ?

Below CREATE_REPLICAION_SLOT not supported by postgresql 14

example osdb_lsr=# CREATE_REPLICATION_SLOT lsr_sync_01 LOGICAL pgoutput;
slot_name | consistent_point | snapshot_name | output_plugin
-------------+------------------+---------------------+---------------
lsr_sync_01 | 0/C000110 | 00000003-00000002-1 | pgoutput

Regards,

Durga Mahesh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Siraj G 2024-09-20 04:07:31 Need assistance in converting subqueries to joins
Previous Message Wizard Brony 2024-09-19 19:08:07 pg_locks in production

Browse pgsql-in-general by date

  From Date Subject
Next Message Durgamahesh Manne 2024-09-25 20:53:39 Re: Synchronize the dump with a logical slot with --snapshot
Previous Message Durgamahesh Manne 2024-09-15 16:43:13 Regarding snapshot generation during creation of logical slot in pgsql14