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 1n8buY-0006p3-3k for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 05:47:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8buW-0005p8-NG for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 05:47:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8buW-0005oz-CO for pgsql-hackers@lists.postgresql.org; Sat, 15 Jan 2022 05:47:32 +0000 Received: from mail-pf1-x42d.google.com ([2607:f8b0:4864:20::42d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n8buT-0007XX-Kc for pgsql-hackers@postgresql.org; Sat, 15 Jan 2022 05:47:32 +0000 Received: by mail-pf1-x42d.google.com with SMTP id i129so4655122pfe.13 for ; Fri, 14 Jan 2022 21:47:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=81cb1A5FDYOs1fEDJsJsE0o+/TCYmEARZY3WYF8TUnA=; b=MvRmjaI8Af+aeJ/X7P7jukCl8A+mWLx85IRwOSpqRZjlwKWG4MDEUv3ttx/iLpkWQa RpE7t1g9CVwxGT2FBQbn5X0DXccU4PfJI9a6xpuqpufMuZ6O7eTDY/OW1pFEvC77Y1Y1 QrnbaXymsaE6cHaQnw3xQpYfit0iI2bsivd2k80Tsn7PCmWGNUASohAYftSzsA0QXxI7 B3hZZ4XgGTxxwgZ6GuZgZxy6ZzL0PoX+YHPBITlqnPOEP5D81XJi6LYZP0486hmWRUfl IWLnIZy21Qwl2JhVHt0GJoGcQXdCB7hUFi+tYTRiUMKQ6fZEaRmhyuEGq0VS6qzwkBuF EyBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=81cb1A5FDYOs1fEDJsJsE0o+/TCYmEARZY3WYF8TUnA=; b=yEOJd8P4HSI2weKmmUuAbXBjn1tlvsyoXQbr2ix4cO4d4E+cJXNSk/aaP4MaA196DD +zWJ2T4LGMPV4IQgXTYP5kUZtJEM3nDvO/jSOPvGFxfk3YO/1vTVuWuk/ZXQxcqTqzzF grmhKWsE4Kd+8jQc3x1tjP9O0XOYXnQUNstcekAiwvmZdQTYe0oLIvs6tFXrnKD8BxtV qerNmNN/xOFBhm8YWquaWQCObDulNDdpG+x458TaFQMcIc0fZedkCaGiNRgXUgipDKH3 e49vBj0Yy3NZ0DzvOBi1ufq0IB3+bc4LbpgUWb1r2addu6Xpc0Hb9VaDYWQ+2/+5Tfng qCxQ== X-Gm-Message-State: AOAM5311qQvu5Wz6ak3Sw84unE2NxXZCp9+BHEJ7cVeQHM1HNjNxPmIg 9ZS+slYOeAAUk8vxMPvtrvc= X-Google-Smtp-Source: ABdhPJy2Mz6VrKjC5ZWOxS/XjatkhsthErDUD4i3KvTE6sx2bE6MaSUe/zkj7zjib6TFfwusIAg97w== X-Received: by 2002:a63:2c93:: with SMTP id s141mr10656239pgs.337.1642225647335; Fri, 14 Jan 2022 21:47:27 -0800 (PST) Received: from jrouhaud (1-171-185-43.dynamic-ip.hinet.net. [1.171.185.43]) by smtp.gmail.com with ESMTPSA id y7sm5138072pfg.195.2022.01.14.21.47.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 14 Jan 2022 21:47:26 -0800 (PST) Date: Sat, 15 Jan 2022 13:47:19 +0800 From: Julien Rouhaud To: Shruthi Gowda Cc: Robert Haas , Sadhuprasad Patro , Stephen Frost , Bruce Momjian , Andres Freund , Alvaro Herrera , Masahiko Sawada , Tom Kincaid , Amit Kapila , Thomas Munro , PostgreSQL Development , Masahiko Sawada , Tom Lane Subject: Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) Message-ID: <20220115054719.yeqoy2mdllbc7wq2@jrouhaud> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Dec 17, 2021 at 01:03:06PM +0530, Shruthi Gowda wrote: > > I have updated the DBOID preserve patch to handle this case and > generated the latest patch on top of your v7-001-preserve-relfilenode > patch. The cfbot reports that the patch doesn't apply anymore: http://cfbot.cputube.org/patch_36_3296.log === Applying patches on top of PostgreSQL commit ID 5513dc6a304d8bda114004a3b906cc6fde5d6274 === === applying patch ./v7-0002-Preserve-database-OIDs-in-pg_upgrade.patch [...] patching file src/bin/pg_upgrade/info.c Hunk #1 FAILED at 190. Hunk #2 succeeded at 351 (offset 27 lines). 1 out of 2 hunks FAILED -- saving rejects to file src/bin/pg_upgrade/info.c.rej patching file src/bin/pg_upgrade/pg_upgrade.h Hunk #1 FAILED at 145. 1 out of 1 hunk FAILED -- saving rejects to file src/bin/pg_upgrade/pg_upgrade.h.rej patching file src/bin/pg_upgrade/relfilenode.c Hunk #1 FAILED at 193. 1 out of 1 hunk FAILED -- saving rejects to file src/bin/pg_upgrade/relfilenode.c.rej Could you send a rebased version? In the meantime I willl switch the cf entry to Waiting on Author.