Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKKZp-0002Nl-FL for pgsql-admin@arkaria.postgresql.org; Wed, 16 Feb 2022 13:42:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKKZo-0000pw-CN for pgsql-admin@arkaria.postgresql.org; Wed, 16 Feb 2022 13:42:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKKZo-0000pn-0u for pgsql-admin@lists.postgresql.org; Wed, 16 Feb 2022 13:42:36 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKKZl-0007Oz-JM for pgsql-admin@lists.postgresql.org; Wed, 16 Feb 2022 13:42:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1645018951; bh=qL/UpyExq+IajNKL6RK7EuUOPDnaZlq6Mx9VR2woV0s=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=Nn5gEKfYnWZqi0csZpnLaai3Qmue/DctSLxpIpXqZsctQ3FlWQjyJrcxNPt3IGdx8 rIri18m09zDXNvCBRJJTqWai8DsvdVLkmyNo+s5+ZbGTqx20nLku96FieOf3CDspP7 BeIzC+NzQf94WqJg0SdF4ST61sznP07KGRzh+32o= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.35.179] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M2wGi-1nH1Br0zbY-003QEv for ; Wed, 16 Feb 2022 14:42:31 +0100 Subject: Re: Differential backup in database migration To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: Date: Wed, 16 Feb 2022 14:42:28 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:WvaShJLCZcp7Wf56prtzNMMlPYGkQ/6w9c9czkn6aLt+myLe7nb dnbxxpy3wYx1Y7RlblL4nl5KjuD/tgYbCB2hswV9b0gT1fcY+ySzoLMgKhNjy4GtOaZ63uk RFAK4LymicUpc6WEkBQr6SkeBxrwSsUErGjqDlxxZ9QRvQYi+khChE7Us7vfC7aTEUfoC3e tt+wBWnyDiwKKtZR2f61g== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:1HQhDyPfMLo=:4CR7HbbJ723baC6/hRBEIZ rOBKlzKb9gkPCzyiI6i8aHwRodYw7C3kVt5B2Cx8XN4lc+1kiwgfKmksL//Xc/uZRSOZkXxTM qpcUiw+f6+Pl+KH3iBoo7vWY2ohgstbAd6atjIhY4x/CQaEsEafciOkIbOqy3X0A/fkO3NeE8 PQd8xX12kXDT8KncUlpxR3kSi4w9tcvPXAv/Q7/otxDkNaMhIFfTZVMVVmWNum0zM7WOdoLoz qIg1YzNXCjYZ0o/IdkeH1Z22znw5vreBIZv51LKpyq4bo/EaZ4E//Id+nR6DR43Fo3qafDkT4 t7d4HjBbWadt2XmsB47VLh1zVD4x7E0agb3VLIZ+sZeB/Unxm7/a3EJuh2326T4VflR1MzP7v X4mNw1KIiRykBvwFQj0qaSkCD/lJuPl8J6QHCO/Fm5oXox2AKDI4DTaBqvVJM3cbeCxjljrSx M2o7ODkI7hek7NWDJPYF7zb2wapnuy4+ntBXsac6WNuPW2U7cJ+pGclEJnlL+NV5VMcY79Q2u crKh5hfqFzSJf/Sf0ltovmHQV41Yu+750Td+fUqFoqhzQol4ymu/K3+26vWmdjwZV7sqDyo3S reoYBE+Z324d0hqwm73ef86lsH9vwdr+xaWxhcPMnvpe2naZ5MFuvMLoY0uzgJVT4HlJ/FO9T Z9uRaD50LI5CbOmSok8hMLSAq/Qx77UKHwIW9Mt3LtjMv5wYyz9QH+sivr6GoyDvsGWDeOBpu Qi97QsEljMzyGvvlgSLWlYMLmvkBtD1LaWTiIgusN1M4jdmBsvzZh+sLD2oLQgfGEXTgeB0a8 JE5la4WIxAQsJzaJdB8FKdAQTVbs7NKJT+wfI0T9lYQEJKvbS7cvwDJaIfLFv/Pp9ZDCDECRP e9Nh9W6cOgHeQSglDxnDIW5Cuov0kfdxrk5451qD+BiLllviVqYsXhwUrfKAyVeegt2t3tUL5 YpPzFvhHbiEX2zFWIOhASa1gwRqRkxk6BSODpS/ElIvRk4eeXgyPJHdR5ARlfUCzy/VGmJVGN emYdEyTimzG/eJniqlhA6zxzdQOzRQ4Ayp243JHUv5zPAIyVrD817G1YNWBoBXtTO/31j8Px2 8+5Bm3RfNtm7bA= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alex Balashov schrieb am 16.02.2022 um 12:24: > I=E2=80=99m faced with the daunting prospect of upgrading a PG 9.6 > installation to 14, in the process migrating a ~400 GB database. Due > to the large jump in major versions, the on-disk block storage of > course will not be in the slightest bit binary-compatible, so I will > have to dump out the DB & import it into the target DB, live via a > network pipe. pg_upgrade will happily do the migration from 9.6 directly to 14 If the length of the downtime is a concern, the --link option will make th= is quite fast. Thomas