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 1srERf-00GFTM-B8 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:31:31 +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 1srERc-0091Yb-Dt for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 10:31:28 +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 1srERc-0091Ww-2o for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 10:31:28 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srERa-001yqa-5Y for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 10:31:27 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-5c40aea5c40so26949a12.0 for ; Thu, 19 Sep 2024 03:31:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726741885; x=1727346685; 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=sZPzZqHNNSrbsl6yBFEwqHcYGTaK6i2nHlFVUacMDTs=; b=UUpCFSA9mAHhE98lVtPwP0gC9L5vf59x3JmeSDsXxC3QO89pMqIpKKG/1uP47o8u2K 0DphW3eNWFmbM5ndYcO9AVVvCC9WaRkGLCdfXiZZQbPdWT3LiCGEK1BjfZb5cb5a5ULZ 51qpBCsBJeoeTOJh0VICBvB706IEc8XcH08XMWH3xw+RBWklJII6cXDb0iXjGc/XlAj/ oXv5m/wc0ZlNoqr5X55AUkieVkiYhkYkN7iLAv9gnIcphiy2MAQrbu2GT0+BdqStREdt zeY7d8hJURZpP7CwB6NDvBadI/7Fl2oMYmJhSWu/j5v7CPPNtQw3rqPZqLPgRWQEdpsV 5h7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726741885; x=1727346685; 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=sZPzZqHNNSrbsl6yBFEwqHcYGTaK6i2nHlFVUacMDTs=; b=TqbCYaKGRhgnT7b9FElwjwDRI0R9yAdaHWG+aj8nSNENFz5hBBo9AZPpiClbwJmmcg OQeGdOvY3yDCX2EjqwcBEF/fYI9k4Qhr/EOvRTItvqEvpWkcpap3j+vqootVb2FFn0Jv NSI2EMMZ8Rxpqk02B9K2rhE74ZwBZ1PXWyjkx6rel8NbHhfdRS1aYRSr5p26/fXd+X4h wmNgap6+zheK7bYTUQ4zoBxUBC/dqKxw8/GoDxW6kW8RMwXVxIdKX4DfW6/8bHa42bl3 qKnLYo6a9oESaUWDI3Kr3AgYnOq1eeRHMxld6BvTnaAHUkt+2BGSxnHGeT56oGn78DRX 4ghQ== X-Forwarded-Encrypted: i=1; AJvYcCVST/wLKHNgnm3YbGuSlB857U2KXkKrxFD6Ujn9r2u37JE2LZOA064B1ggnzcXuiTPma+80BaE7/oMWOg==@postgresql.org X-Gm-Message-State: AOJu0Yx9hQWVvWCzr+OgMVh3BqGPMxnMhfo86eCWKltFJTVE/un7UVre FAJJTDwluT4F7isuWVGVrbPagpmKCBFoeZ02oa7tTc6ugjcvxo0U8zxLHnJHTHy5QCEdLs12BJM AIcj293cAUOVJ27wHpZ1llrEuOX8= X-Google-Smtp-Source: AGHT+IFurg/Sz1X4UhMEiayAP4avSHQsXLYENK7KIvbSiIMFlDqXCDnDDoOtN9pvNJlbO7fTQc6k3vx3dqvaeM0Xiok= X-Received: by 2002:a05:6402:5206:b0:5c2:7741:7d82 with SMTP id 4fb4d7f45d1cf-5c459222b3emr2743187a12.11.1726741884341; Thu, 19 Sep 2024 03:31:24 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Zaid Shabbir Date: Thu, 19 Sep 2024 15:31:11 +0500 Message-ID: Subject: Re: How to install specific postgres version / downgrade in Ubuntu To: kamal deen Cc: Muhammad Usman Khan , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="000000000000a295220622766cb0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a295220622766cb0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 postg= res >>> version to match with our primary node. >>> >>> ( replic sync also not happening due this version mis match ) >>> >>> Pls advise. >>> >>> Thanks in advance. >>> >>> SK >>> >> --000000000000a295220622766cb0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Thu, Sep 19, 2024 at 3:27=E2=80=AF= PM kamal deen <kamaldeendba@gm= ail.com> wrote:
Tha= nks 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 please make sure you t= ake the proper backup.


SK


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 PostgreSQL
Uninstall PostgreSQL 15.8
Ins= tall PostgreSQL 15.7
Check Replication

On Thu, 19 Sept 2024 at 15:00, kam= al deen <kamaldeendba@gmail.com> wrote:
Hi Team,

We have observed post OS patching one of our replica server got auto upgr= aded from 15.7 to 15.8 in Ubuntu , we wanted to downgrade the postgres vers= ion to match with our primary node.

( replic sync also not happening due this version mis match )

Pls advise.

Thanks in advance.

SK
--000000000000a295220622766cb0--