Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1spsJk-0056YQ-75 for pgsql-general@arkaria.postgresql.org; Sun, 15 Sep 2024 16:41:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1spsIk-002k9G-4M for pgsql-general@arkaria.postgresql.org; Sun, 15 Sep 2024 16:40:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1spsIj-002k91-ML for pgsql-general@lists.postgresql.org; Sun, 15 Sep 2024 16:40:41 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1spsIg-001JQJ-QT for pgsql-general@lists.postgresql.org; Sun, 15 Sep 2024 16:40:40 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-5c42f406fa5so779376a12.0 for ; Sun, 15 Sep 2024 09:40:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726418437; x=1727023237; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=QknKsRvRY+wPQY4wi3zCkoZdIxg2brBcAuDapJHYXGI=; b=cGKBVkrHHYkjBYuAC3dXqDy/1/Kw4hBUvU5TT34jakqUSxCefpXvrTXC4icf1xddP+ 5GbQ5X6sgRMVGTXZ9y8iBR6ukM7xc3cEJbaYpZCxgXzX8hJ4Hx0rpdlSX8lDJZw0/oG9 Q3sKKsc+VyAPeBUc4mBHinAEysGxM/a+P2CX2IY6cviFtmZKsOo0JLD9pa2HThjnLNiB ftp1dXcOdNzQf18U8eB4K6DAI2wHT/YlA2r2+ofSN7hpzsTvxDVFfn3S/lOCXmmja4BC GX/rObrw5EJZbuP4HUqoUHAGqbUdvy3XU2fNUYhbbkwOcX3yAyjIiUTW2bU8ECKgQ8FS nrVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726418437; x=1727023237; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=QknKsRvRY+wPQY4wi3zCkoZdIxg2brBcAuDapJHYXGI=; b=pmuJjuMldGdqji4x68dVHYwjSXMmQMQXb52imsIz1IkfAiG+4Xuypab4TVau+ueGME agNey7ujh0d5wPXGvf55Br0A6GSVJQteXoUIvhMRS1MKu4Lv14pXaxwCb02xilyiavNk nHwV7x+WIQH5SjfZYMJt39zHXBoBhbZd+hMeqPoAnkwVYpcp3raac3Bpn6xh5DUqsuvS ieq5i/UdWVlKE31DjrhM6s6mfZjUASZeUAKdi3tXXEYM1EHSyDngVa6fkoB3cNgJL/Wo JGU+A98YI/hXpDxvQq9h2P1hqvYV4ffIUwT0iagtaXRU4SsC1etuiVDFBNXJ/4G0mECC t+Tw== X-Forwarded-Encrypted: i=1; AJvYcCXMAMBW8gNk7c09I6jNL3/BVZM/24FBeA5oWU8zYZu+5/6nU/GpBQeAhfylfh1J3MhxVITK28mpk/Q/xAou@lists.postgresql.org X-Gm-Message-State: AOJu0YyTyCB6CNAGbmhwJA0Gbak52t5Ai9dJSRXGQ1pj7Fnk8AUEflr5 479Vd7k2bICvR6E9Mb/wCR7Fq61LK5mPIblfVJUO7pVe6a7SI+5cqJGjIf043xMU5nwJuRl3Y00 ThI1skN/SKNYqrZsZrYaqb6LaHGNiHw== X-Google-Smtp-Source: AGHT+IEIfWtkMlUbfXLn5woscVQH1Mx3q7PktjtE/61U3VWCYBmNeo8ULuRYQdEsNksoSa8WopBEHIj662ZgigXs/6c= X-Received: by 2002:a05:6402:e9a:b0:5c4:14ff:8a7 with SMTP id 4fb4d7f45d1cf-5c41e18bd36mr16087928a12.14.1726418437087; Sun, 15 Sep 2024 09:40:37 -0700 (PDT) MIME-Version: 1.0 From: Durgamahesh Manne Date: Sun, 15 Sep 2024 22:13:13 +0530 Message-ID: Subject: Regarding snapshot generation during creation of logical slot in pgsql14 To: pgsql-in-general@postgresql.org, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ad289d06222b1d81" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ad289d06222b1d81 Content-Type: text/plain; charset="UTF-8" Hi, How do we generate the snapshot for the logical slot which can be used in pg_dump command options with --snapshot in pgsql 14? Any function to check the snapshot of the slot after creating slot with pg_create_logical_replication_slot('pgdg',pgoutput); Regards, Durga Mahesh --000000000000ad289d06222b1d81 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

How do we generate the snapshot for= the logical slot=C2=A0 which can be used in pg_dump command options with -= -snapshot in pgsql 14?

Any function=C2=A0to check = the snapshot of the slot after creating slot with pg_create_logical_replica= tion_slot('pgdg',pgoutput);


Regards,
Durga Mahesh





--000000000000ad289d06222b1d81--