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 1uAVn4-00GDqT-Hi for pgsql-general@arkaria.postgresql.org; Thu, 01 May 2025 15:25:35 +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 1uAVn1-003b38-Fn for pgsql-general@arkaria.postgresql.org; Thu, 01 May 2025 15:25:32 +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 ) id 1uAVn0-003b2g-Fi for pgsql-general@lists.postgresql.org; Thu, 01 May 2025 15:25:32 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uAVmy-000Xfx-1U for pgsql-general@postgresql.org; Thu, 01 May 2025 15:25:30 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfhigh.phl.internal (Postfix) with ESMTP id 675931140236; Thu, 1 May 2025 11:25:27 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Thu, 01 May 2025 11:25:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1746113127; x=1746199527; bh=CVAFT360QU6CooqKpsAKKxx+B9JUX/o0WDY+kxdYsow=; b= O9XW8uJbf8Rtqjrtbi6NAPVdtyPv93bcZ7hY8D3RtDBqpl8Us4qZXmR70OY5lhvr 8yUsjo4Kqa40jfI/jMBAPbvhNcYyRMWyRQXdgaBBshGZqNL5HuogmEMLiZvZ2u1p mmdFXS09boMZj8+73B0eLTlq7L3Tl2lgCtSqLeD7AiCWOvjAzcrNl1ZcLd3uTGV2 FlGWoVKhCOXc2VlPQWaAVeFlcqFT8Gf8AMyij4ayI51wBrwTeZCeMfqinei3Ems3 VBPTLyfOm2eCxa0oXVInXA7pVPn43+I0rlRFI/dG/8a1MN8jJISlMBohSXAtlF7t S9n8wwSjFJQZwycmCZwn9w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1746113127; x=1746199527; bh=C VAFT360QU6CooqKpsAKKxx+B9JUX/o0WDY+kxdYsow=; b=uGI7ibEXek2WtwTN+ PlkEXROjwsuE3woLgDrl3i54ey+6EsdYJP/JW0P9ukP0DmjrJd9El4UqL+WYkq1S MwMWroJP6NjSboGtnVns1jOaFNlwUHq2yhs+cSr275rIbdlSbzun5t2GFTb4/OQz qHmB03soT0Efhu7B9+T9uYbjaNurrlsMA1ug+TVEUOUrnyaxeNaLucHvYzcyVALA syZXhCjriXTCyfT+qzuE0t8PlmKt7ivbY6GOllKK4IeqMOhzqFVO8wm2kE0/6h9S aVuYwqOoINCSCGenw7b4gatfTN0Ihw1mFT60gYZzpP/dRL1OB8Jqq99ooSIslakM 26C8A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvieelleefucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeeivdfhieehheegueei leejieettdejhedugeefleekvdelkeehtdfgiefffeekudenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopeguuhhruhhmuggrrhgrsehgmhgrihhlrdgtohhmpdhrtghpthhtohep phhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 1 May 2025 11:25:26 -0400 (EDT) Message-ID: <52321b99-9a4e-4761-bc1b-fe9d2f5c2e15@aklaver.com> Date: Thu, 1 May 2025 08:25:25 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Upgrading PG11 to PG17 without dump/restore To: Durumdara , Postgres General References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/1/25 06:06, Durumdara wrote: > Hello! > > There is a heavily used server, with older debian, and PG11. > The data is more than 1,2 TB. > The PG_Upgrade is not possible because of lesser space and too old debian. 1) Specify what the old and new versions of Debian are. 2) I don't understand what the following means: "The PG_Upgrade is not possible because of lesser space ..." . > But this seems to be very hard, because we need to do this through an > internet connection, and the data is too much. An Internet connection can be dial up speed or direct fiber speed, you will need to be more specific about the connection capabilities. > Best regards > dd > -- Adrian Klaver adrian.klaver@aklaver.com