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.96) (envelope-from ) id 1wga3f-006Gy0-1Z for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jul 2026 03:31:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wga3e-00EgrS-06 for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jul 2026 03:31:46 +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.96) (envelope-from ) id 1wga3d-00EgrJ-2P for pgsql-hackers@lists.postgresql.org; Mon, 06 Jul 2026 03:31:45 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wga3b-00000001kAu-4AHC for pgsql-hackers@lists.postgresql.org; Mon, 06 Jul 2026 03:31:44 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-384c94c9414so750934a91.3 for ; Sun, 05 Jul 2026 20:31:43 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783308702; cv=none; d=google.com; s=arc-20260327; b=ERYwebiL8zCz3f6LvCVMsKt0qazYmx4stgjnw6rH+EtPexo5JTJx9MtcIoHSnz+rqt /f0Di1J3F7Lrny36Ub8C3Am3Qlk/zbUZfHkMWr5N7x1TZUWf5Xvwb6RA0ArjQ7hbQsfe NpzZl7VLHncSqcwnXmXkq54k0Qhg6/gWjabcDsqKIgJiqJeD9k72MAP8ObpohitltLf3 4gkZ8xcHaiMOyKgkcprcjvWPPICi0OnEALf1pGcMg4b6s/sGgMbs6qXUlvRgngzlD/dB X0pj1GtPlqhZZfMW1pFL+CmYvDkgIF3/Qjv9Yfc1M6+s7XA+njMrtl72BeES8IqAL09J ooaw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=2qAGPCutYQE8WhJZ03gUzRVVq5Oqo7wsZDcpw0Wro0E=; fh=/uSQpmoPIAlQIxF+I0Y2vwuwOpyhv4Jcwjz+YybbrtU=; b=W8u1Z7RYDFldOIAE7tbyQh0OitIguFsrPCAL6xQ5SXoLGU4FuR7G6jeq8JgxD7AURc XVlr62nNyxzNrqGVFGWy9Us+JcpdAGBXHH6UXars19fIzWLs08pvLM5YqEqALBo/DCpK xd6IFMkorlvm4Uhr72touaMCyZZ7jPnX4m+AHWRQUgTKFUbIZPLpnOq0ndtQ1Kwh/Rta IUs7FFGVm+eDJvrzYHUGtn5OUyRBPvW3cNdKwBS5+Fpx7qJVWdDIe39fmTEwRrAUFFcC 8XlffjUh8zsjZjWwEbgPHEmEPm7C49T5GV84/1+HRhEJm8/UPD359RQBz6cNAgLvOnG2 YGPA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783308702; x=1783913502; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to:content-type; bh=2qAGPCutYQE8WhJZ03gUzRVVq5Oqo7wsZDcpw0Wro0E=; b=VHTzPNO0qZ68+rpv0I2rxc9qYj+uRxrZr5V7M6RmYFPLcFGKVhYV2LW4X1waBJDJfA OdfaDykDuNcWG7Mj3bKka4C1ySZ5eZOdEUiHZzncA5igPYxrHfWZw0RC1h3gQxGG2Qrf T0tAJF6VZ+AmooTPKNCtXdDI35USGENvTr8cUculCZ7lTraoGx9tPRiS38iyhEF1j8/M bgBlkFMdNCDWmd64wMTUqoXhKl6bjkomg/A407kuP65fqe7fI0OilW01IXxvo/n52zQQ 1Vz/ZJJ2VjtApd+gR6BkNcJTc+q9C8BNgKsjLv/ic/YkowrdTWpoTuU/RpmMgTS+HHA0 pt3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783308702; x=1783913502; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=2qAGPCutYQE8WhJZ03gUzRVVq5Oqo7wsZDcpw0Wro0E=; b=FO3wjMzoXYjsI26u8r7dboZkEOWVUNQXz5PwESevtXJT3zGlTPh0nmUE3zY1c7J9PJ GOWXdjKJYiZ3vgv+4FAxcrr2aZimpkVCj7pEh1LgWwNrqAsKN6/D1cvYLv1KyUEMOvUE 9hf+Eyn/7QurVOV9ozXwDMjE+rW9wYSN9ufMEzZU3YURQi0celIuISLVcVuET+iUwYz6 kyXz+4lEuWHoMH/GsFlbO2ABsu2fivXyKtFd/5h+ATP8UbJAolXM7AsD49h8qiI0A1di MZfPBBiBQWEBwHKyqA7xR0HZK+N7ly8AG9/fzHBvUsDjDC35Ew+G1cq8hQqY9eOp+zpm cjPQ== X-Forwarded-Encrypted: i=1; AHgh+Roggo9RFx43f/byvTwYr28IAPOkJvrqJwvg9BGvqDFGARiLw/IOP/4jOv4TB4+TMlbRQvz2MqhtWvYq57yY@lists.postgresql.org X-Gm-Message-State: AOJu0YwEWb/KR5khlsiRtEqCxvBoAnzaGFkuWPv9YnMad4MjCozqxZwR CxeXwn3Y6ksypdA3IN966aPtk5HpBZB0C7DjAzfTNqr3whH9DoMOv2amMlQNbyGWylJb0kcnZXp zQXqzxJflrd0neKA/z1D4gz4MsTiD9xQ= X-Gm-Gg: AfdE7ckw0XH/dXTduvhjqCUZelZivTSsMNoTqkV5Vpt2PLWXPRR6hyHyZrvoljq0jUq lqDlGhUrtkXzQzVh0PLm2IAZIZClXQcdje+c1uCYnhAQDetBFUBLWUEKIs+7dqTuDk6oBCo9j7Q NDGcaNzhIDX3r1/nZ529JFY9AaWvtZJ1C5QoC7v3xZek6iaC4NN3peNDzTOyFJC0rOFJGBdmjQo t5Wk9M4cwrB5li5x4ao0XKhwdU92Zz+JHBFpzWLTs8olXu59lREcsm7PvL8Jc1kY0V8WcY+VBrg hE6FAa/fBwOu/G1ySzfZaMnPuTFqL8zniul15NH2GoVU1CjTvzqWInySX2FsxVJy+YhFJV/87a4 = X-Received: by 2002:a17:90b:510e:b0:37f:133a:3e09 with SMTP id 98e67ed59e1d1-382803b483amr8001768a91.3.1783308702136; Sun, 05 Jul 2026 20:31:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Mon, 6 Jul 2026 09:01:26 +0530 X-Gm-Features: AVVi8CdEgM0zqCc_iwQAh--dvtSGTsYeS0QRZfpGU-irYZobByYK17Cr1dF3M4M Message-ID: Subject: Re: [PATCH] Preserve replication origin OIDs in pg_upgrade To: Rui Zhao Cc: Ajin Cherian , pgsql-hackers@lists.postgresql.org, Zsolt Parragi , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Jul 5, 2026 at 9:40=E2=80=AFPM Rui Zhao wrot= e: > > Hi Ajin, > > Thanks for v10. On the version gating I asked about earlier -- I think it= 's > now moot, and the gates can come back out. > > Since v10, 14d8418083 ("Remove pg_upgrade support for upgrading from pre-= v10 > servers") raised pg_upgrade's minimum source version to v10. > pg_replication_origin has existed since 9.5, so every cluster pg_upgrade = now > accepts already has it, and the original unconditional > get_replication_origin_info() is safe again. Both gates that went into v1= 0 are > now always true: > > - check.c: if (GET_MAJOR_VERSION(old_cluster.major_version) >=3D 9= 05) > - pg_dumpall.c: if (server_version >=3D 90500) -- only reached under > binary_upgrade, i.e. against the v10+ old cluster > > 14d8418083 was itself removing exactly this kind of pre-v10 version check > across pg_upgrade, so dropping these fits the same cleanup. > Thanks for pointing to the commit. > v10 doesn't apply on current master anyway (0002 fails on pg_proc.dat), s= o > could you post a rebase? That'd let it be built and tested against HEAD, = and > it's a natural point to drop the two gates and go back to the uncondition= al > calls. I can apply v10 on the latest HEAD (9d1188f298), can you please try it agai= n? thanks Shveta