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 1rX5dz-008j8V-GK for pgsql-general@arkaria.postgresql.org; Mon, 05 Feb 2024 20:32:44 +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 1rX5dy-00FqDJ-Jp for pgsql-general@arkaria.postgresql.org; Mon, 05 Feb 2024 20:32:42 +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 1rX5dy-00FqD9-90 for pgsql-general@lists.postgresql.org; Mon, 05 Feb 2024 20:32:42 +0000 Received: from aart.rice.edu ([168.7.56.48]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rX5dt-005db7-IG for pgsql-general@lists.postgresql.org; Mon, 05 Feb 2024 20:32:41 +0000 Received: by aart.rice.edu (Postfix, from userid 18612) id 36780C15214C; Mon, 5 Feb 2024 14:32:35 -0600 (CST) Date: Mon, 5 Feb 2024 14:32:35 -0600 From: Ken Marshall To: Andreas Joseph Krogh Cc: Wyatt Tellis , Ron Johnson , "pgsql-generallists.postgresql.org" Subject: Re: Improving pg_dump performance when handling large numbers of LOBs Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Feb 05, 2024 at 09:17:53PM +0100, Andreas Joseph Krogh wrote: > > På mandag 05. februar 2024 kl. 21:10:53, skrev Wyatt Tellis < > wyatt.tellis@gmail.com >: > > No, we don't have the ability to make schema changes and the schema in the > PG15 copy needs to match what's in the PG 12 versions > > Well then, I guess it boils down to how badly the ones in charge wants this > migration… > > -- > Andreas Joseph Krogh > CTO / Partner - Visena AS > Mobile: +47 909 56 963 > andreas@visena.com > www.visena.com > Hi, Can you use logical replication? Then you aren't under the gun to make a fast copy. Regards, Ken