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
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 |
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 |