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 1r0iwK-007PP2-23 for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 13:49:52 +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 1r0iwG-003YrY-Jx for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 13:49:48 +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 1r0iwG-003YrP-8v for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 13:49:48 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0iwD-004ZTP-VF for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 13:49:47 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-d865854ef96so7120295276.2 for ; Wed, 08 Nov 2023 05:49:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699451385; x=1700056185; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=yNB3d3sIOin8YoLN/PtkUogSYyeKpGiHOKzKR5C9PzE=; b=eze3yqq8eBalxstR25EGYnKQQ90azn1+rnhHvKzh1AeXljJXQTYmsY+DHkrZsk6IRc VPvunhTm91xAnybvf8OIOZLaVZA2UPT4BpaBU2Pkkjmn9gxZS0HfZOwMUKLFDbaNZ/Or gzrBVzuExROypMQWzDpm10FBkCdBt3YctX4OZyiIfG2A4ejiVpZ1BAatTfXLWHcA7iTb oUBlW6F5+WbAKKLq6cAFWFJlnD2izSFjh/TW9VrrOU+yBEFaNEYEkOizukc0wZVmZEU+ LwbkJlrbdIaHll3OrwmT3tDQ8+gsPX1PyIlMhVI8xvo3EAoZVM+cscGVssPUWosfeasg T2rg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699451385; x=1700056185; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=yNB3d3sIOin8YoLN/PtkUogSYyeKpGiHOKzKR5C9PzE=; b=Z6/YkrGH4OC0zFVoMkr+ZW2oZBWNIwAIYMlL6OvMT38D9UPyiutAiBm2xf03kCgZkV k6fTP9FTq6nHb7U9WKWXUDz6GWSvVD0ii6wxhAsXeNv6e3mLWxoaFpIyi/hL7+EcsqM3 WZCiyANOyXhRVBLEMtJrvHD/ej6KKEWXYMAY/jaiH5jJd17mo82zUkjzdblC2B2yMIeg ChJd6WG4wEl5kbMNVVWnlHi/AVOgEaPMTZB6fk1LVYrZfLy4+wZRGO2fSsDWXlg5WBel DrwBqOsBiiPK+ymGg9JT4hoa3eXZnjLhg7YVLDBLVgDyZkDjYGC4C7ZrDpEu8U0z5vw7 YGNA== X-Gm-Message-State: AOJu0YwCfEwjvBWA5arr0skPhHlrbPLqeIBsXAyxaB7WfvRtiomwvNi/ KgJOuMCPBgho33UbacFpL/yg98Uax4w= X-Google-Smtp-Source: AGHT+IHHjJHhQtRvOqcIZpPtUfTOBNlx9wlt5CjBd8SkFw/LFXX8i9rskDQeW0IygVset/PClobMkg== X-Received: by 2002:a05:6902:100d:b0:da0:571e:fa1c with SMTP id w13-20020a056902100d00b00da0571efa1cmr2085407ybt.29.1699451384814; Wed, 08 Nov 2023 05:49:44 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id o68-20020a257347000000b00da0abddeb02sm6440542ybc.34.2023.11.08.05.49.44 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Nov 2023 05:49:44 -0800 (PST) Message-ID: <7ab796b5-d60e-404b-a13f-e24ae3a68414@gmail.com> Date: Wed, 8 Nov 2023 07:49:44 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Operating system upgrades on PostgreSQL nodes using streaming replication Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <216fb159-31c7-e1ee-e792-c9eee255ed1c@ebi.ac.uk> From: Ron In-Reply-To: <216fb159-31c7-e1ee-e792-c9eee255ed1c@ebi.ac.uk> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/8/23 06:29, Rahat Agivetova wrote: > Hi All, > > We are planning to upgrade the operating system from Centos 7 on Primary > and Standby PostgreSQL nodes that use streaming replication to RHEL 8. > What is the recommended order to upgrade OS from Centos 7 to RHEL 8? > Standby first, then Primary? Can there be a small time gap between the > upgrades or not? libc change means possible collation change.  That means I'd do them both at the same time, then rebuild any indices with TEXT, CHAR or VARCHAR fields. -- Born in Arizona, moved to Babylonia.