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 1soMfH-00Aeza-Ll for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 12:41:44 +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 1soMfG-00GrfL-Mn for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 12:41:42 +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.94.2) (envelope-from ) id 1soMfG-00Gre8-Aa for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 12:41:42 +0000 Received: from mail-oi1-x22a.google.com ([2607:f8b0:4864:20::22a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soMfC-000e2P-W2 for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 12:41:41 +0000 Received: by mail-oi1-x22a.google.com with SMTP id 5614622812f47-3e0465e6bd5so1496671b6e.2 for ; Wed, 11 Sep 2024 05:41:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726058498; x=1726663298; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=f2s6LKk7CHF8e6sigpMnaKbJLPEYJ575MV2QP7/4HgI=; b=NfVHFDLgafuT6mXK7oS8rfj53BwkCRGyWzikCmpbSuBzVhMFoQPlFaArVsm1L4FkTW X7bgNMncxsBtoN62VrW+9YdgGcAB0Wg+8S5cH4Tfmey/c8w0TVN907JrJhfM+ppGg6hy ysCZS0fbSxM+VR0GhWa5XdcYFxX0Tb6z/R2ao3GUQ+96H0HrhvceX3x1+MdEakzJCVnW cCc18lg2h6br7IfFr517Kk/cb5WA1sYH+x5VpBUujLBmSl013LxfJhmQw2ncsHvzbytm SE2yowqNDRKbdlRYSCCREDgUxXUXwuA10/fEKTHaxm1S5fjBQaKDyvpMyHHjLpjlJS4r hWdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726058498; x=1726663298; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=f2s6LKk7CHF8e6sigpMnaKbJLPEYJ575MV2QP7/4HgI=; b=UaszdoKatddK7Le9TPGxm1BgOspjhAbXlTz88zNAPao4VRmUiAF924rLMI8SkLU9Kk 8J6ZhBashVl6uynSy9Pi00TLP7663U2Y8HWyPqdEywwefnywH6tjTUJchuclXeuvxsAW T23v8MbGl8uEGIBfySTNE05HnfNp3RB/D9VqrM2TS/pH1NJMkjh1em9iCi+XqO8jUZcR eq+g6Ai01fnJO8gyDfuY28PLg94QEGTlaRDlmbDw+CUYGAZrl33wkuCXUHeAlPQ+L/ni dMBIhwMP6i3g+a8w2/WWknwn20pDVNDXcsoeTaEw+hUAPSphfyUDyI0RchY6ixdkHfPm CCRA== X-Gm-Message-State: AOJu0YyVJGw+CCjy55/C9md0Rk+Orw966DL5g9WV65EMrmrdHoTqSXbh PIQfEnIvkkgWdEQt/toCEP5jcGdY/bp+IJhE/QpmU5u24UWi2fsRFE4NQ0blxAtxNlaBbUgwUbO HQBplTFVc8BZ05zv5lIN6Tjf3zbREwQ== X-Google-Smtp-Source: AGHT+IEk7mUqH5EnxR+W9ES2d6w+hXJt+QO8BqHqln/QsMYpCEPs0kh4KZpOHZoQM/CzCPSDVvVFeut5w4jd+iBUnqg= X-Received: by 2002:a05:6808:19a7:b0:3e0:4758:8ed5 with SMTP id 5614622812f47-3e047589095mr7160185b6e.10.1726058498130; Wed, 11 Sep 2024 05:41:38 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Wed, 11 Sep 2024 08:41:27 -0400 Message-ID: Subject: Re: Patching Postgres from 15.5 to 15.8 To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000a48b430621d74f71" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a48b430621d74f71 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Sep 11, 2024 at 4:28=E2=80=AFAM Asad Ali w= rote: > Hi P=C3=A4r, > > Yes, it is okay to download and apply the packages you mentioned manually= . > However, I recommend that you first take a backup of your existing > PostgreSQL data before proceeding. > 1. OP should be backing up anyway. 2. PgBackRest (and probably others, like barman, wal-e, etc) does "continual backups". Thus, no need to take a pre-update backup. --=20 Death to America, and butter sauce. Iraq lobster! --000000000000a48b430621d74f71 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Sep 11, 2024 at 4:28=E2=80=AFAM A= sad Ali <asadalinagri@gmail.co= m> wrote:
Hi P=C3=A4r,
Yes, it is okay to download and apply the packages you mention= ed manually. However, I recommend that you first take a backup of your exis= ting PostgreSQL data before proceeding.
= =C2=A0
1. OP should be backing up anyway.
2. PgBackRest= (and probably others, like barman, wal-e, etc) does "continual backup= s".

Thus, no need to take a pre-update backup= .

--
Death to = America, and butter sauce.
Iraq lobster!
--000000000000a48b430621d74f71--