public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Smith <[email protected]>
To: vignesh C <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: DOCS - clarify CREATE SUBSCRIPTION only synchronizes sequences when copy_data=true
Date: Fri, 26 Jun 2026 10:49:36 +1200
Message-ID: <CAHut+PtOkYeHd6vkA4ZOvMj9E1ZJVVQ_XJbRmJviTYowVPh6zw@mail.gmail.com> (raw)
In-Reply-To: <CALDaNm1xY_Js5-jppiBzGq2HMqzCHk+LLpupfWp_cFcG=vJXmg@mail.gmail.com>
References: <CAHut+PsrVntfrJ8gV45+6=1bs5dTWD5mU7Q6aKrBnf1vmyZQkQ@mail.gmail.com>
<CALDaNm1xY_Js5-jppiBzGq2HMqzCHk+LLpupfWp_cFcG=vJXmg@mail.gmail.com>
Hi Vignesh.
Thanks for reviewing!
PSA v2 worded slightly differently to mention the copy_data default.
======
Kind Regards,
Peter Smith.
Fujitsu Australia
Attachments:
[application/octet-stream] v2-0001-DOCS-clarify-copy_data-is-needed-to-synchronise-s.patch (1.0K, ../CAHut+PtOkYeHd6vkA4ZOvMj9E1ZJVVQ_XJbRmJviTYowVPh6zw@mail.gmail.com/2-v2-0001-DOCS-clarify-copy_data-is-needed-to-synchronise-s.patch)
download | inline diff:
From ac68db98a923d629d02401acd47226839e7ce5fa Mon Sep 17 00:00:00 2001
From: Peter Smith <[email protected]>
Date: Fri, 26 Jun 2026 10:43:41 +1200
Subject: [PATCH v2] DOCS - clarify copy_data is needed to synchronise
sequences
---
doc/src/sgml/logical-replication.sgml | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml
index 9e7868487de..71405259d03 100644
--- a/doc/src/sgml/logical-replication.sgml
+++ b/doc/src/sgml/logical-replication.sgml
@@ -1769,7 +1769,9 @@ Included in publications:
<listitem>
<para>
use <link linkend="sql-createsubscription"><command>CREATE SUBSCRIPTION</command></link>
- to initially synchronize the published sequences.
+ with <link linkend="sql-createsubscription-params-with-copy-data">
+ <literal>copy_data = true</literal></link> (the default) to copy the
+ initial sequence values from the publisher.
</para>
</listitem>
<listitem>
--
2.47.3
view thread (4+ messages) latest in thread
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]
Subject: Re: DOCS - clarify CREATE SUBSCRIPTION only synchronizes sequences when copy_data=true
In-Reply-To: <CAHut+PtOkYeHd6vkA4ZOvMj9E1ZJVVQ_XJbRmJviTYowVPh6zw@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