MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sun, 15 Sep 2024 17:14:58 +0530
Message-ID: <CAJCZko+_R35ss00YjSaTqqk++UOvmMqbmEn63kGTDzFs0W81gw@mail.gmail.com>
Subject: Generate the valid snapshot during creation of for the purpose of
 taking pg_dump with --snapshot option
To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org, 
	Greg Sabino Mullane <htamfids@gmail.com>, Koichi Suzuki <koichi.dbms@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000000b3b27062226f35b"
Archived-At: <https://www.postgresql.org/message-id/CAJCZko%2B_R35ss00YjSaTqqk%2B%2BUOvmMqbmEn63kGTDzFs0W81gw%40mail.gmail.com>
Precedence: bulk

--0000000000000b3b27062226f35b
Content-Type: text/plain; charset="UTF-8"

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

--0000000000000b3b27062226f35b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi pgdg team<div><br></div><div>How to generate snapshot_n=
ame for required slot on latest=C2=A0versions of postgresql=C2=A0</div><div=
><br></div><div>Below is the generated slot and snapshot info on postgres 1=
0</div><div><span style=3D"color:rgb(51,51,51);font-family:Menlo,Monaco,Con=
solas,&quot;Courier New&quot;,monospace;font-size:13px;background-color:rgb=
(245,245,245)">osdb_lsr=3D# CREATE_REPLICATION_SLOT lsr_sync_01 LOGICAL pgo=
utput;
  slot_name  | consistent_point |    snapshot_name    | output_plugin
-------------+------------------+---------------------+---------------
 lsr_sync_01 | 0/C000110        | 00000003-00000002-1 | pgoutput
(1 row)

</span>But the same way i could not able to generate on pgsql 14=C2=A0</div=
><div>Here archiving=3D&gt; select pg_create_logical_replication_slot(&#39;=
pgsql&#39;,&#39;pgoutput&#39;);</div>=C2=A0pg_create_logical_replication_sl=
ot<br>------------------------------------<br>=C2=A0(pgsql,3080/12DD6468)<b=
r><div><br></div><div>archiving=3D&gt; select pg_export_snapshot();<br>=C2=
=A0pg_export_snapshot<br>---------------------<br>=C2=A0000000C7-015658E6-1=
<br>(1 row)=C2=A0<br>in this case pg_dump fails with invalid snapshot ident=
ifier when i use it as=C2=A0<span style=3D"background-color:rgb(245,245,245=
);color:rgb(51,51,51);font-family:Menlo,Monaco,Consolas,&quot;Courier New&q=
uot;,monospace;font-size:13px">--snapshot=3D</span>=C2=A0000000C7-015658E6-=
1 in pg_dump command line=C2=A0</div><div><br></div><div>Need to generate v=
alid snapshot for required slot in order to take backup=C2=A0</div><div><br=
></div><div>Regards,</div><div>Durga Mahesh=C2=A0</div></div>

--0000000000000b3b27062226f35b--