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.96) (envelope-from ) id 1wcckE-003Uic-39 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jun 2026 05:35:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcckD-003rOX-28 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jun 2026 05:35:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wcckD-003rOO-1C for pgsql-hackers@lists.postgresql.org; Thu, 25 Jun 2026 05:35:21 +0000 Received: from mail-dy1-x1329.google.com ([2607:f8b0:4864:20::1329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wcckB-000000009BM-0LP0 for pgsql-hackers@lists.postgresql.org; Thu, 25 Jun 2026 05:35:20 +0000 Received: by mail-dy1-x1329.google.com with SMTP id 5a478bee46e88-30c713f37c2so525650eec.0 for ; Wed, 24 Jun 2026 22:35:18 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782365715; cv=none; d=google.com; s=arc-20260327; b=soPq3c0vxrE1LSOptE1+hKMwU9ZSfHl4zT4saHOVBztcOjCIralMq2T1mZQPeQ7OWi WeNprUjm4XKau1SB9S3izems/TzOyEysM+Tu1jtvFsXRtJHDQc4N03E55FtPyx7exR4Y b1xxjGrmrNwKbprgJZ0tUDy5dQCS+xw06XHFY7mfWxbWwzCmrA87mK8eGRHyV7Lb6tMG 07b4ME4nS1iSPgiqNiYiHBTsiHdoYUrUmYm5Z6lbbhbzbcbGzZ7ZIHPOPhK3rUb8aPUL EVqmOERZ9OV+xjZBElr7s2uYvkubarLzLbpq0g9yhPImWy1fbyeveMfxNrpTLW+kLvz8 k1Dw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=1+wUWnT62+mrSocee/mPsFHqk7U5KSl7FZGgZpG57G4=; fh=XRw5J5i3Z9psIyguu48sxtbp7lY/wCEo7+jKa40enyw=; b=BWrrcjjcXzq9JGvtJ/l0vAa3JLg9R4/iiP53tvNU9fNuyAdUoX+98CcXLPXa1p2YPt SulMCwJCULhinCySeEJgY20HXBstsjrRcEsBGnuVstNtjQ8k8OO7OBJQWyT5m7k4dkTX 1XCMhEwj6MnThsNA9uY8VGBaUNzzfMX1v6K9ssL0OrNnSMjYuRHYvoiX0rqqjkApSYZw n+52cKJtNzoSOlPXZi2oNEPxClgPbkrEpX6nSmp+7D8onJSnZSGJeiQiW2+KSpnPxq1j /Bwo0rw88ebRfp+g36lNdATil0g3FZJ84zyIih5TQZSwaGIPmbUzVnziEIZByNOYxh07 hRsQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782365715; x=1782970515; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=1+wUWnT62+mrSocee/mPsFHqk7U5KSl7FZGgZpG57G4=; b=YvTonH3WlKniEFQ51cCekURk9IbQjw3x9BvMCFGHA+uslx6M1XHXgEuYip/MGsKNr4 Ye3NCHc7wDAateao7SEY6EIZ0rjQN90W4qW0SjrSzX+FJgKnob2u3LkgXJ72S4r1kP0k W2TdbcH2Pds5/Yjmz9xsTMYUjgmNuW4lO/yE2jR45sAnzh5oc1lEuyrvrA4J8cKPJXzt ihdhvr5Djmfy6WNOldlQcwCd348RU0NtfsujN4mM3zgnl1fqpfDQo9Hc3fM1JpdYKd+O eZClMYCgtMCmA4pd63O9QSUJPDz42q0QtLfheccRImPFkFWNyCpsCz0cX86uf8VlBigd 9KQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782365715; x=1782970515; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=1+wUWnT62+mrSocee/mPsFHqk7U5KSl7FZGgZpG57G4=; b=XwaJk4YVPMHxEIsXEp0dOVeUPR8KgruA5xvNUF75+S7pR2Ja66rkY9VctoafK+e8BK fbon2JQpdrCYDApzqp39DcturRWPOzepmTMroJv3yS04ImN4ClGetKQBbbPY4jRdoxHt xxHUn+cP4YKXWIa4j9JGnhmgjpMlbxEDE7t7LAzlYGQm+XHL26LR58MDYX0YF5twRJ6W PcO66IGGIURSJgpL8UxFjeeJz+rp/sLLotqhS1WfvX4WkTbFgvxG5WbjOQi0INgK/ycY ojxZQz4GWRcLTLiHCr82NcrxZqLLqCMRd+84esVgL090eGh2qUxRJjBbqLuiaR6mAf26 lQIg== X-Forwarded-Encrypted: i=1; AFNElJ+91oDhfOSjiiYE8CBPp9LZfrNHUsOadArn4vJeIeEDBip3KKiw7j9c58Uf4BAQuaq4qrrT0VFK82Suyv2r@lists.postgresql.org X-Gm-Message-State: AOJu0YzRqcM/BlhIDaPJriMR8thP74wmcJJmFbmcwZuDnxrwWaBgcA4+ Tmx1IHeoJ80sce8z6iDp50LU3cbh8Nkra+G3BrfdPJaMUQyj2k0KAeIwa7TGQxzxyWcwVD9R8Cn egt7vodRb5XGq6KMninvNn+wcl9vHwulJ9sy7KXg= X-Gm-Gg: AfdE7ckeeGUQUAMKgRAXc5b5IxkjpqX+Cf5W4TacuQV4f7wZfj67PJSUFRhORZk0DxA JX4ZvMn8Dll3fQE6wjR+CXZuqAABSTBvJZtguzEz8s7+9wrRVPXQaQ6AqNlJzQLcmkNvjTeECy1 D/vfvSpihNaZGyKExAUmi7XCzQYECK3MbADX6XhnrIFN+z++LBbSSwmBW2cg6z2R1puckvvcKjh oemtynDHXpOyXvqAplwrfuGQ1tl7x6l1ZSVez6WTvLiFB0XfF/KUXJuHPj0cW0PV5F/rArkrQPW 5XNzUgZ/UQtnHETMYVx9qtwCviQ4D9Xa5eqLzA== X-Received: by 2002:a05:7022:21e:b0:137:ee08:ad37 with SMTP id a92af1059eb24-139db9d6544mr972387c88.13.1782365715336; Wed, 24 Jun 2026 22:35:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ashutosh Sharma Date: Thu, 25 Jun 2026 11:05:06 +0530 X-Gm-Features: AVVi8Cf_8DC4XLLK_p1Y348SFTE6LZPJnb4OfN9J1z-DMXyYiUfMXrdha6NMsIM Message-ID: Subject: Re: Include sequences in publications created by pg_createsubscriber To: Peter Smith Cc: vignesh C , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, Jun 25, 2026 at 6:29=E2=80=AFAM Peter Smith = wrote: > > 3. > > Enable the subscription for each specified database on the target = server. > The subscription starts applying transactions from the replication= start > - point. > + point. The subscription is configured to include sequences. > > > This implies there was some special subscription "configuration" for > getting sequences, but it just gets sequences because sequences were > published. Maybe you don't need to say anything here. Or, maybe reword > to just say "The subscription will include sequences". > What if the subscription uses an existing publication that doesn't include sequences? In that case, would it be correct to say that the subscription will include sequences? -- With Regards, Ashutosh Sharma.