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 1srF1z-00GJPx-2q for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:09:03 +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 1srF1x-009b36-Qm for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 11:09:01 +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 1srF1x-009azk-9s for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 11:09:01 +0000 Received: from mail-pf1-x42d.google.com ([2607:f8b0:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srF1u-001xiS-P3 for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 11:09:00 +0000 Received: by mail-pf1-x42d.google.com with SMTP id d2e1a72fcca58-718e6299191so351986b3a.2 for ; Thu, 19 Sep 2024 04:08:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726744138; x=1727348938; darn=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=d1/SrODRpfKjGIGv1jjnnKPQ1O9s87rJddlUUnGK0F4=; b=jxpbGwHRd03JTsYyzisp1SF0wI4tIJzABTL9CJXzAFV9CLKWpvuiT9lA3/QFgH5bVn USdFOWbjhZBnjaohVUrV4HTYnNbPY97BfxpCvI85MuucTcKeghZu0JOpxImfGR7UfCT+ aq67Wt6V0jnQbVaO7To6c9o3HV3yfrk9Bt9uPRofNrwi0mJG2e80SeWto1DFzez7WriX zxEdOIXG6F4oEZPnilV9rUCR7QewOydWPIkcm+pHoMQO6skCCuM2rUfkY19i883IYZdc iwFlynlyRdlZaV6RHhP0nAsTDP2PJeEip52kkGZg8wWtqqVIeWfkDAPJPfFNOc3uEH4Q 1JIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726744138; x=1727348938; 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=d1/SrODRpfKjGIGv1jjnnKPQ1O9s87rJddlUUnGK0F4=; b=VlT2+S3bJyxM5sww0n2sy39600MhEWuYOBANPZRDbsoe0CUSHhF2BZYouXoag3WPts w9d7z97u4ck6VhqrJ9cP7YOFyN1vBlKWmHdM7UFA5UTp/SmYc1XlV03dOhB75hxpIZqE QnMOtDAksKlsLl3kgO1Hucay7iPHv9Ni/lVdl5M31g2ssRMiGQv4zN13WXEsJG/tvdoQ LB0I37kAa0aF2m3B1TOgL2D0Hkc2heAFytC7rCPcNfUUC9D3k0f31cpkc7fGN08j/rbX P+Cwr0txxdMYsFyWmpNk5MYmEEamJPMSn6rYhqHkC8cHHrjTgIiLMCOETluDVWBvcFKz zErw== X-Forwarded-Encrypted: i=1; AJvYcCU4misvggvYJ/eXjviGmb+Kd2kH6r9GyN+PN0DrWACnOCOo20E7Sw32SVHOOlcseRkQ6PBJUt38G1uSZw==@postgresql.org X-Gm-Message-State: AOJu0Yxnh0UvbCjk71YP6WGsQLNuAB+Dva+V/+zxhWdvY5cPedqkD/xR xxB+y2+fDFop5UQ/tKVY30CSw2+Yf0JFL0eenL/rH4AbHWoFMqRkPo+Ayr/HFbepiuxncHve/NW UDzB322elFmYsoxuPVTePQv3EtJM= X-Google-Smtp-Source: AGHT+IEPvTu0W0F7POj2XJPoO9Ovzxn//t4LVPG8Xdp/LwP94MGloIotJvcJF01vRsvKwZVnfkl7kSnxcsA6ZpcrdHM= X-Received: by 2002:a05:6a20:d80b:b0:1c4:dfa7:d3b9 with SMTP id adf61e73a8af0-1cf75f0051bmr39543192637.28.1726744137733; Thu, 19 Sep 2024 04:08:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Thu, 19 Sep 2024 16:38:47 +0530 Message-ID: Subject: Re: How to install specific postgres version / downgrade in Ubuntu To: Zaid Shabbir Cc: Muhammad Usman Khan , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="000000000000f2a117062276f2c5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f2a117062276f2c5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Appreciate, Thanks for your response. SK On Thu, Sep 19, 2024, 4:01=E2=80=AFPM Zaid Shabbir = wrote: > > > On Thu, Sep 19, 2024 at 3:27=E2=80=AFPM kamal deen wrote: > >> Thanks for your response, >> >> I would like to get the exact commands to use. >> > > apt-cache showpkg postgresql-15 > apt install =3D > > Note: Before downgrade operation please make sure you take the proper > backup. > > >> SK >> >> >> On Thu, Sep 19, 2024, 3:35=E2=80=AFPM Muhammad Usman Khan >> wrote: >> >>> Hi, >>> I think the only solution is to: >>> >>> Backup Your Data >>> Stop PostgreSQL >>> Uninstall PostgreSQL 15.8 >>> Install PostgreSQL 15.7 >>> Check Replication >>> >>> On Thu, 19 Sept 2024 at 15:00, kamal deen >>> wrote: >>> >>>> Hi Team, >>>> >>>> We have observed post OS patching one of our replica server got auto >>>> upgraded from 15.7 to 15.8 in Ubuntu , we wanted to downgrade the post= gres >>>> version to match with our primary node. >>>> >>>> ( replic sync also not happening due this version mis match ) >>>> >>>> Pls advise. >>>> >>>> Thanks in advance. >>>> >>>> SK >>>> >>> --000000000000f2a117062276f2c5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Appreciate, Thanks for your response.
<= br>
SK

On Thu, Sep 19, 2024, 4:01=E2=80=AFPM Za= id Shabbir <zaidshabbir@gmail.c= om> wrote:
=


On Thu, Sep 19, 2024 at 3:27=E2=80=AFPM kamal deen <= ;kamaldeendba@gmail.com> wrote:
Thanks for your response,=C2=A0

I would like to get the exact commands to use.

apt-cache showpkg postgresql-15
apt install <package-name>=3D<version>= ;=C2=A0

Note: Before downgrade operation pl= ease make sure you take the proper backup.


S= K


On Thu, Sep 19, 2024, 3:35=E2=80=AFPM Muhammad Usman Khan <usman.= k@bitnine.net> wrote:
Hi,=
I think the only solution is to:

Backup Your Data
Stop Postgr= eSQL
Uninstall PostgreSQL 15.8
Install PostgreSQL 15.7
Check Repli= cation

On Thu, 19 Sept 2024 at 15:00, kamal deen <kamaldee= ndba@gmail.com> wrote:
H= i Team,

We have observed post = OS patching one of our replica server got auto upgraded from 15.7 to 15.8 i= n Ubuntu , we wanted to downgrade the postgres version to match with our pr= imary node.

( replic syn= c also not happening due this version mis match )
Pls advise.

Thanks in advance.

SK
--000000000000f2a117062276f2c5--