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 1vQjq9-00GRVJ-18 for pgsql-admin@arkaria.postgresql.org; Wed, 03 Dec 2025 10:12:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQjq7-00CcRa-2x for pgsql-admin@arkaria.postgresql.org; Wed, 03 Dec 2025 10:12:04 +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.96) (envelope-from ) id 1vQjq7-00CcRQ-1i for pgsql-admin@lists.postgresql.org; Wed, 03 Dec 2025 10:12:03 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vQjq5-002tlG-2L for pgsql-admin@lists.postgresql.org; Wed, 03 Dec 2025 10:12:03 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-640a3317b89so10268516a12.0 for ; Wed, 03 Dec 2025 02:12:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1764756715; x=1765361515; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=zwgiu1CjTmTmcpyJJQ2xvgECzXJsf9bWjf0mjn32hc0=; b=CmE/loYsRyliR7PxP1+IoQsbNcdM6Sd+QaK8p9WXapTDum+VsWOHRbQsY5hHR6bjPy rPNwQaxgsCra7CJ4MMmMGrtDHhkxd07QxObLUEVToUxSOtXUwGc+yvCwBSaMOfAUOkUL G+vly4bEu8v2X73OnUammBGRiXNNi6+UUB22vc++V6/UYZnwrf6vnJnT8ET4Pz+qyzCG oeHDBDlpCDe427VTmeZlZ/nrbI5tgQatSghWY2sjII16nmbh9uLILveVHlDQ4CAG23p7 S/16pul9H8O5XAEwr0JtZ/wWpAxkVWHfr1AZ2taLDITELflCk1KW2WqXXP4UeLy94+nz k6IQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764756715; x=1765361515; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=zwgiu1CjTmTmcpyJJQ2xvgECzXJsf9bWjf0mjn32hc0=; b=ZqjRvY/WV7+IZIEKi3fpJvxOjoB1jM6a3TLYyAQ+24STSFSkDT2XJ+4RYaWg/gr6eE /lSxNeQfAi/jdOOTeh3l7dfEJTPwvz1vArswuhVPsssGyICe3XCarX4HcKLZedZYEELS X4H4pjnbezZmLV+p+5DYiBwHd7pz7H4+W45UgCINbeETMusymLjZXwxnvtrlONWZ7W3B RtHf7Pwk++c/cNTsHpAHAnaoinwY9P/3Ya+wL6dar3tm0X112KogNwSz1lSE9PQMR1nb vpQOR2PYcg4vw/JDxAD4iGXsg2aEdplWW6PhN+qMAH/i2tEwLltpok1iRAS4jvZnQMQD LZ0A== X-Forwarded-Encrypted: i=1; AJvYcCVqqI4tTbFSe+XC/ohwiONwbmR1f0aIutoyZ7pgKCLwMYRYYflJOTu8sr3bX+Z2pw+tmRAKPtHka7N7dg==@lists.postgresql.org X-Gm-Message-State: AOJu0YyVJCBmfSICe2Q8uFqTOqqSOxpHEoRfGaBoMO/RAKJ5xy+mEKSU K7dj8uGYJTm+C8p00ean+vkm2P0EAGYKKXnrZdmAN9FzY76jUS01rlyoKR42LnJn7aU= X-Gm-Gg: ASbGncug2wmvK5DqylPJwYMESZ9rxRt0VtwsL4986Glq5/Fgxsa92UCmgNR5m49mzVr bu+ik3bCpOJ3z8y4DxDashaR0R4m/yrpb5JhsWUm2z+kC7RXQF16bAsDZQe4z7sVZCpbdjvROl+ L34CISutl6/psDbYK7XMIYCv7dgQTlY2yITliwox97sYL4qeJFhc+fPICSkKBwOB3F4lvts8fGa fV5DL0iULcvhzn+pvfhlarhtd91SM6r1Py8Q57tbbrTmkHGBH+rc/wsarF8p0TNzHGeRZFal6Hr cHwHecViTZPh2J211p/Z+yjpyVyeEaa8T4Tl4uGTLdAiZqp1C9fgPdbBAHJiTrc/GadGwDV2gKj ToYT4kLyDw/d4OlFVIBeqzG3VQzmXQL1gs82HEOGCnlfGGcpzyytRpoSAwE1BxUpdghtp6GEnwm WbMA29lNuO5NLiPrKZKM0IG5Rs4Gg6oWD0SQqU+E2gi84DayjeNek= X-Google-Smtp-Source: AGHT+IEcq7WzAd7aG0a4KymIE3ua4Bq12s6lUH3xXo9P4WMFeAPkXUg59dZb7f/jK+iD+Gntml9Z+A== X-Received: by 2002:a05:6402:146d:b0:641:9aac:e4a9 with SMTP id 4fb4d7f45d1cf-6479c419de1mr1379945a12.15.1764756715211; Wed, 03 Dec 2025 02:11:55 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:9a9f:8b16:e05b:d5cd:4b07]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-64751035b75sm19604125a12.20.2025.12.03.02.11.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Dec 2025 02:11:54 -0800 (PST) Message-ID: <9f346a8d50f09d3ec73697012b3b763064d8f639.camel@cybertec.at> Subject: Re: Cross OS version streaming replication From: Laurenz Albe To: Nikhil Shetty , Pgsql-admin Date: Wed, 03 Dec 2025 11:11:54 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-12-03 at 14:24 +0530, Nikhil Shetty wrote: > For upgrading the OS from CentOS7 to RHEL8, I plan to create replicas on = RHEL8 > and then perform a database switchover. After switchover, I will rebuild = the > indexes affected=C2=A0by glibc change in REHL8. Is this a good option to = perform OS > upgrades with minimum downtime ? Yes. Two remarks: - Logical replication might be faster, but it way more complicated. > Postgres version: 15.12 - I'd update to 15.15; you should always run the latest minor release to av= oid bugs. Yours, Laurenz Albe