| 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: | Whole Thread | Raw Message | 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 |