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 1tpA4i-001H2C-CA for pgsql-admin@arkaria.postgresql.org; Mon, 03 Mar 2025 17:59:32 +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 1tpA4g-00D7qA-9O for pgsql-admin@arkaria.postgresql.org; Mon, 03 Mar 2025 17:59:30 +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.94.2) (envelope-from ) id 1tpA4f-00D7pE-8t for pgsql-admin@lists.postgresql.org; Mon, 03 Mar 2025 17:59:29 +0000 Received: from resqmta-c2p-569298.sys.comcast.net ([2001:558:fd00:56::4]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tpA4X-000kaK-0Z for pgsql-admin@lists.postgresql.org; Mon, 03 Mar 2025 17:59:25 +0000 Received: from resomta-c2p-555483.sys.comcast.net ([96.102.18.238]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 256/256 bits) (Client did not present a certificate) by resqmta-c2p-569298.sys.comcast.net with ESMTPS id p4fmtGxffQ3gcpA4MtpOn8; Mon, 03 Mar 2025 17:59:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1741024750; bh=SnXsQVYGHmBm+uEZyBYzicB/3KanuEBa/oy4B+YVeCQ=; h=Received:Received:Date:From:To:Subject:Message-ID:MIME-Version: Content-Type:Xfinity-Spam-Result; b=R1Aliy69tR/ZVZXDzv6bA5sXsfqdut4JqTfUU/g/4UXJXcIXHmulryFFrpplNjbhZ EbK3OgGZzO039IzOxjkstyV4wwDD2PrAIuxDLkTLivFjUCgVL7eyVoXJ+l8pyKdlrr zeiupCyLNeLUmMWzp9rgEpLhyOACz5qo0gxb/9h54rD7wBcjLxc7IdGDqZ5MF4bpMZ L9+OUgEDtElq0H1Tl28ZC87gZHG1Xejv4Ao/mP77I7cPd/d1CIm4EyX4WWhjr2uwlG Bgo+iYnBOk/rnsqQqABJ5N7ZV/F5Iq6pVCY1nNjKrT6t8fMAjDPkCRMXB3sMbQ4nab qN3uc5QproBIw== Received: from [127.0.0.1] ([194.124.76.85]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 256/256 bits) (Client did not present a certificate) by resomta-c2p-555483.sys.comcast.net with ESMTPSA id pA4EtguYjLnFspA4EtczZQ; Mon, 03 Mar 2025 17:59:07 +0000 Date: Mon, 03 Mar 2025 12:59:01 -0500 From: Mike L To: pgsql-admin@lists.postgresql.org Subject: Re: Create Publication v12 User-Agent: Thunderbird for Android In-Reply-To: References: Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----YA7WH960NALYW54DKBGJYNERQNF0O2 Content-Transfer-Encoding: 7bit X-CMAE-Envelope: MS4xfN3dPcTEqRXAZHljE3v3OIDvcTjHcX3DheemNRIamVV7W1HQovU9xvnszU2DNVD7N/b4TowTCSoiS87BeBgs5mKJfb1XdY94dgzecjptWPDJAE0r1jxz gd3j403QBK+qL0kDdn8p5OqwwrN0TodQP+/PbtcR9hOMLK9BvC2SA64zmbjq3yo/JxWFe5Z6t+9cQ2ImWw2HopoAEBR2ZnFSAak= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------YA7WH960NALYW54DKBGJYNERQNF0O2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Well this is an Aws Aurora Postgresql 12=2E26 version cluster=2E The goal t= o upgrade this clusters, since it ran out of standard support 2/28/25, to 1= 6=2E6=2E Due to size of clusters I am doing blue - green upgrade using 'fas= t clone' then upgrade that clone to 16=2E6=2E This will lessen the downtime= =2E So over 50 schemas in 12=2E16 publication has to be created in that versio= n to get to 16=2E6 On February 26, 2025 3:32:46 PM EST, Thiemo Kellner wrote: >If it has been added to v15, why not upgrade to the newest version? Sound= s to me like a sound use case=2E Mike L ------YA7WH960NALYW54DKBGJYNERQNF0O2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Well this is an Aws Aurora Postgresql 12=2E26 ver= sion cluster=2E The goal to upgrade this clusters, since it ran out of stan= dard support 2/28/25, to 16=2E6=2E Due to size of clusters I am doing blue = - green upgrade using 'fast clone' then upgrade that clone to 16=2E6=2E Thi= s will lessen the downtime=2E
So over 50 schemas in 12=2E16 publication = has to be created in that version to get to 16=2E6


On February 26, 2025 3:32:46 PM EST, Thi= emo Kellner <thiemo@gelassene-pferde=2Ebiz> wrote:
If it has bee= n added to v15, why not upgrade to the newest version? Sounds to me like a = sound use case=2E
Mike L
------YA7WH960NALYW54DKBGJYNERQNF0O2--