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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1suibs-009CU4-4s
	for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Sep 2024 01:20:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1suibr-00Frzz-Eu
	for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Sep 2024 01:20:27 +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 <bruce@momjian.us>)
	id 1suibr-00Frxl-59
	for pgsql-hackers@lists.postgresql.org; Sun, 29 Sep 2024 01:20:27 +0000
Received: from momjian.us ([72.94.173.45])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1suibo-001YkE-Fh; Sun, 29 Sep 2024 01:20:25 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2024011501; h=In-Reply-To:Content-Transfer-Encoding:Content-Type:
	MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To:
	Content-ID:Content-Description;
	bh=X2n8hFY3DpsnhHYTVgALfy6TwSs0/6Wri49vLroDtv8=; b=QwdHjkpqvMQ4o3hhaNCvuheU4r
	SI2grCUHvYbQ6Qf9IArVaRX2GbzNkIFYvLDk/MWvFWNNPL6j9EYBojZZyZrz139axpZwn1OLiOlMn
	N+J+DixADtbuFvEkfB/kw8b0TfpX+c+5viBOUMTxPhfmwGatpWCZYWJJ3m8eoNLFiJ3yEozGwNb68
	UpCvoq6ZoFtj52NfwgXOROrS3SfgSL4MCTVrftkUXI0jCyoolqm4Cnzz0847eA82buKOUhRITWqP4
	YSieI6VWmHBUvrbkf+lMI6zpL0o5nUBaWBpQNVhtpxyzQizzK+Qvcagh0p6UOb+EjG7k1QjVi17p1
	H7eH0FtQ==;
Received: from bruce by momjian.us with local (Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1suibm-00DiMw-13;
	Sat, 28 Sep 2024 21:20:22 -0400
Date: Sat, 28 Sep 2024 21:20:22 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "Jonathan S. Katz" <jkatz@postgresql.org>,
	Laurenz Albe <laurenz.albe@cybertec.at>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: First draft of PG 17 release notes
Message-ID: <ZvirViPO4TJBmVxG@momjian.us>
References: <ZjxLJpnH4VMkOMmi@momjian.us>
 <0749f42a-17e1-42c9-a8d4-542fcb9fafeb@postgresql.org>
 <7fd6ce37f6d14678b5024767aef7f8c5a414ba0c.camel@cybertec.at>
 <d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org>
 <Zu3UWHKwuzm-pVJo@momjian.us>
 <2536416.1726862711@sss.pgh.pa.us>
 <Zu3Y9ObRxWu8cUwm@momjian.us>
 <CAA4eK1+bChgccySmcm0LbvkmBDJ3ufsLneF4iNa_aZ7t2P6=8w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAA4eK1+bChgccySmcm0LbvkmBDJ3ufsLneF4iNa_aZ7t2P6=8w@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/ZvirViPO4TJBmVxG%40momjian.us>
Precedence: bulk

On Thu, Sep 26, 2024 at 03:08:52PM +0530, Amit Kapila wrote:
> On Sat, Sep 21, 2024 at 1:50 AM Bruce Momjian <bruce@momjian.us> wrote:
> >
> > On Fri, Sep 20, 2024 at 04:05:11PM -0400, Tom Lane wrote:
> > > Bruce Momjian <bruce@momjian.us> writes:
> > > > Patch applied to PG 17.
> > >
> > > I don't see a push?
> >
> > Push was delayed because my test script found some uncommitted files due
> > to earlier testing.  Should be fine now.
> >
> 
> <para>
>          <link
>           linkend="app-pgcreatesubscriber"><application>pg_createsubscriber</application></link>,
>           a utility that creates logical replicas from physical standbys
>         </para>
> 
> This description is okay but according to me, the more compelling use
> case is that this new utility helps to allow online upgrades of
> physical replication setup as explained in the blog [1]. See the
> section: "Upgrading Streaming (Physical) Replication Setup".
> 
>        </listitem>
>        <listitem>
>         <para>
>          <link
>           linkend="pgupgrade"><application>pg_upgrade</application></link> now
>           preserves replication slots on both publishers and subscribers
>         </para>
> 
> It is better to write the above statement as:
> "pg_upgrade</application></link> now preserves replication slots on
> publishers and full subscription's state on subscribers". This is
> because replication slots are preserved on publishers. The subscribers
> preserve the subscription state.

So, as I understand it, this preservation only happens when the _old_
Postgres version is 17+.  Do we want to try and explain that in the
Postgres 17 release notes?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  When a patient asks the doctor, "Am I going to die?", he means 
  "Am I going to die soon?"