public inbox for [email protected]
help / color / mirror / Atom feedFrom: Durgamahesh Manne <[email protected]>
To: [email protected]
To: [email protected]
To: Greg Sabino Mullane <[email protected]>
To: Koichi Suzuki <[email protected]>
Subject: Generate the valid snapshot during creation of for the purpose of taking pg_dump with --snapshot option
Date: Sun, 15 Sep 2024 17:14:58 +0530
Message-ID: <CAJCZko+_R35ss00YjSaTqqk++UOvmMqbmEn63kGTDzFs0W81gw@mail.gmail.com> (raw)
Hi pgdg team
How to generate snapshot_name for required slot on latest versions of
postgresql
Below is the generated slot and snapshot info on postgres 10
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 (1 row) But the
same way i could not able to generate on pgsql 14
Here archiving=> select
pg_create_logical_replication_slot('pgsql','pgoutput');
pg_create_logical_replication_slot
------------------------------------
(pgsql,3080/12DD6468)
archiving=> select pg_export_snapshot();
pg_export_snapshot
---------------------
000000C7-015658E6-1
(1 row)
in this case pg_dump fails with invalid snapshot identifier when i use it
as --snapshot= 000000C7-015658E6-1 in pg_dump command line
Need to generate valid snapshot for required slot in order to take backup
Regards,
Durga Mahesh
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Generate the valid snapshot during creation of for the purpose of taking pg_dump with --snapshot option
In-Reply-To: <CAJCZko+_R35ss00YjSaTqqk++UOvmMqbmEn63kGTDzFs0W81gw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox