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 1qE0jr-0002AU-JQ for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jun 2023 04:55:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qE0jq-0005rX-Ff for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jun 2023 04:55:38 +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 1qE0jq-0005rO-1C for pgsql-admin@lists.postgresql.org; Tue, 27 Jun 2023 04:55:38 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qE0jk-000iXF-IG for pgsql-admin@lists.postgresql.org; Tue, 27 Jun 2023 04:55:37 +0000 Received: by mail-wr1-x436.google.com with SMTP id ffacd0b85a97d-3094910b150so4899583f8f.0 for ; Mon, 26 Jun 2023 21:55:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1687841731; x=1690433731; 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=RuGUZ2RqybeUT4CPuxtZK5NzfrZHJZLFPoyR8j+4R8g=; b=CuoL5UUhsMyMdKOArQ92s/VaK7dd2GhCYWRx1WfXOSmlMnkLgxQpipOuTHsT8qdOSH bqNeMwzpDXbDHBv+XaygX4Tif/yUg1XfQEXEyBCI/TW5axgbXOJszv8zjJLUs6fIDCP4 SzgN3ehy8Xh7e79ClTa9wIB7wdT2JZKZZzzxSzri/hzDYAQq17atG3BusU67AY2HRKqD AaCyh31CTjKmxWw/0VHgmNAEpcdEA40u4JrkObRn0qQ2B+De6lEO3dD68wBjNX1k8fSs uhxSxRPY3cpgB+GkVWXuHY0+Fp35FmLYQ8nkdBWj+W7ucJNS/x+7JjEkOuzmgWEXTnnD x5mA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687841731; x=1690433731; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=RuGUZ2RqybeUT4CPuxtZK5NzfrZHJZLFPoyR8j+4R8g=; b=hYdKDOfZQuIXn8jnImHPNvm1zJ3E1Weq4nj9UQPZXZM6TPkGhGWTgDbW/n3LmA0kTb Uols+DT0djIDVxTMqMUzkFQR9tGjZdAzkmteAgaSQy3tXGBcAlNfjCZtrHjKIhhuT4Fr g10SCvgxhznEVBCch3d2S+gmYc5NnPtLDUAngwnvlWzVEMsQOQBGaK1nIFgjCOlgsdtR MAUpqVoUYfzTWzq5Z8RIKa9DLupiik6r+hdL1GXJryZm/v+oBw+x+OCJcHN/YO8M///P CnunC1ssFvAxvhrjLPcROcI2d88pFwxLfIwM9Xb5uQM1/VmN091GBaUhB6TCdwLH4NzL x9AA== X-Gm-Message-State: AC+VfDyI35vrdPJi4DFyM0c097U6cj966Oj1J7O+BAXOoSNBfmllmhtG CYsRdXrPM5FvQhO75OHiw396s+hJLFzeBDHpeBw= X-Google-Smtp-Source: ACHHUZ7QzbqMlhGXhvlv6L0Cu+JxDRozkgm3mjcZ2K0XQ5/HWcbPA+lr7HJAiMwtBvEzbgd1z8TtVg== X-Received: by 2002:a5d:58d8:0:b0:313:e2a2:fc80 with SMTP id o24-20020a5d58d8000000b00313e2a2fc80mr6981843wrf.33.1687841731638; Mon, 26 Jun 2023 21:55:31 -0700 (PDT) Received: from localhost.localdomain ([185.109.152.102]) by smtp.gmail.com with ESMTPSA id s4-20020adfea84000000b002ca864b807csm9367140wrm.0.2023.06.26.21.55.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 26 Jun 2023 21:55:31 -0700 (PDT) Message-ID: <934bce53fc35f29afda69c03b48410e1a83c25a7.camel@cybertec.at> Subject: Re: Linux in-place upgrade From: Laurenz Albe To: Murthy Nunna , "pgsql-admin@lists.postgresql.org" Date: Tue, 27 Jun 2023 06:55:25 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2023-06-26 at 18:22 +0000, Murthy Nunna wrote: > The URL posted is taking me to "19.6. Upgrading a PostgreSQL Cluster"... Right, my mistake. Collation changes are the only thing you have to watch out for. So rebuild indexes on strings (and, as Jim wrote, assess your partitioned t= ables). Yours, Laurenz Albe