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 1uPFLM-003H6w-KC for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2025 06:53: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 1uPFLK-00H1Qw-G0 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2025 06:53:51 +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 1uPFLK-00H1Qo-4j for pgsql-admin@lists.postgresql.org; Wed, 11 Jun 2025 06:53:50 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uPFLJ-001O1K-0n for pgsql-admin@lists.postgresql.org; Wed, 11 Jun 2025 06:53:50 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-ade30256175so905407466b.1 for ; Tue, 10 Jun 2025 23:53:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749624828; x=1750229628; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cRbzw6XtZlNUNnN1wOxQNQ+CEL06c+sm1ZFosdYr1b4=; b=V/PXgTjXKo1rCnI2XBAJWn13eg1wGh/14VBVI0P8wcs1rGkMHVbJcQkxyz2xS0/jXG eknX+uSXkdLL+Xbj/VCyeujyhcLfDxaNId5S9nPmijPWAUVTValtOkW2G91cbY41zvnO 8J/kwtr0bx3CfruHmIgCa2Y4P3CXSFDlsncXUqX4e+1vXfR//zkaBDpBasHq5Mlu6jum tyGCYYcjI0SL+QQZPNQfGgqYVQVoGv84/JXHMxsqQXf/pdfZtzV6aNByEPhoEx6g64uO WheQPbU9gw3nr/AzSgzf9iV5BXU+yI/8HUHnF/Rk/YxEiD/SAUaiIgl+64EbDG6+n6z7 nWbw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749624828; x=1750229628; h=cc: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=cRbzw6XtZlNUNnN1wOxQNQ+CEL06c+sm1ZFosdYr1b4=; b=g5n1gvUSt04rKho7d9UnXjBpBgFu1itcBCoxVCLYEwgVg/Bm0ABBzuE2ANOEAdX60p RkXnyvRBtfgJVT2sI5eI2xbPWUNnIzC69hOyY6qEFkU7hxU6NTtsbNan6jml+4PddPZi LHq2CHRbaIIq3HxDeu0QF5uwTBopYkoQQS7KdYpR0LeAotbH73oNXWo2VW8S3Hcar0+Q VCkQR5wx/hSPespKYmaQMeNAXaqf70Vhj4yagiUGUja+p2qc4jz29L8KpldeYs4AtC9N fXkHqf3vZ9w1F9Wb0doe5Ndzx5HbfAAAdPSjr4thidMnrzbjcin3eY8ykF4RtUGzb0TD WG4A== X-Gm-Message-State: AOJu0Yz0KVfkXNPwIffbsUhe+ITOTubu9YHgdrge5fH2UWP7O9tUYSHH iumAXwDqxQiHwwfAMq+zeypayf+o3k9Xe9VwFxVSJcWaOdrP4bKj+5n4l8otPPDbaoCFidcEETZ Qh9woirs/ZG1/sY1cmjxKjo4+K6KDVhY= X-Gm-Gg: ASbGncuyH9oKJmYVHhHTk4siC5ANZEMmauxsxEws45eAnLHXbsQkSzci7UK/B7I9PVd h9Fxgu0YUh861hDeJ7FIEOlm1YvMmSU43RbvsjwPXSIoQGIfJVhhFihcHsgcfUbyDcDreC7kBTU AdbBJiIEl1XKLT+ziXQoAAbzPom9D3sJF3CwLg2xNEzu0GKnO/6teV7qkoSvKnTZrR4y98JLatc Xg= X-Google-Smtp-Source: AGHT+IEM4OA+CXVAoEEJKqI4sdgACVa7WaTBm8k/G1owjw6XUWNXskl7kwtckNBa0YBI480JX59bXmgaQLVYHqXSm7E= X-Received: by 2002:a17:907:3d0d:b0:ade:3a1b:88a4 with SMTP id a640c23a62f3a-ade8944a1c1mr197388266b.17.1749624827442; Tue, 10 Jun 2025 23:53:47 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Wasim Devale Date: Wed, 11 Jun 2025 12:23:34 +0530 X-Gm-Features: AX0GCFvRy-Hstmsip8lkNblDT6HDiivcfuDbnJdcgFLziqjtJoDYmZ0YzQqZDiM Message-ID: Subject: Re: Upgrade from 12.22 to 16 To: Laurenz Albe Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000054843506374646a2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000054843506374646a2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I mean to say that we do not want to do the in place upgrade also the other option of taking dump and restoration of it. If I can have any robust plan who all have worked on that then please suggest me. Thanks, Wasim ---------- Forwarded message --------- From: Laurenz Albe Date: Wed, 11 Jun, 2025, 12:13=E2=80=AFpm Subject: Re: Upgrade from 12.22 to 16 To: Wasim Devale , Pgsql-admin < pgsql-admin@lists.postgresql.org> On Wed, 2025-06-11 at 11:51 +0530, Wasim Devale wrote: > Please suggest me to upgrade postgresql: 400 GB data with minimal downtime apart > from in place upgrade. We have it on red hat 9. What do you mean with "apart from"? Yours, Laurenz Albe --00000000000054843506374646a2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

I mean to say that we do= not want to do the in place upgrade also the other option of taking dump a= nd restoration of it. If I can have any robust plan who all have worked on = that then please suggest me.

Thanks,
Wasim

--------= -- Forwarded message ---------
From: Laurenz Albe <laurenz.alb= e@cybertec.at>
Date: Wed, 11 Jun, 2025, 12:13=E2=80=AFpmSubject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60@gm= ail.com>, Pgsql-admin <pgsql-admin@lists.postgresql= .org>


On Wed, 2025-06-11 at 11:51 +0530, Wasim Deva= le wrote:
> Please suggest me to upgrade postgresql: 400 GB data with minimal down= time apart
> from in place upgrade. We have it on red hat 9.

What do you mean with "apart from"?

Yours,
Laurenz Albe
--00000000000054843506374646a2--